Count a specific month in a column

[Elaine]

Help,

Been working on this spreadsheet and it is starting to drive me Mad, I am
trying to count a column which it contains text and numbers, I am trying to
count every cell that contains the month July with no success.

I have tried wild cards and a pivot table, this give me a total of 6 when
there is only 4.

What am I doing wrong - please help

 

[Mike]

Maybe something like this
=COUNTIF(A1:A5,"july")

 

[Elaine]

Hi Mike

I have tried that it appears as zero, so I tried it with as a wildcard and
no no luck still appears as zero

All the column has is this:

17/07/2008
15/07/2008
18/02/1900
18/02/1900
07/07/2008
18/02/1900
04/07/2008

Trying to pull out the number of July Performance reviews

 

[Pete_UK]

Try this:

=SUMPRODUCT((MONTH(A1:A7)=7)*(YEAR(A1:A7)=2008))

Hope this helps.

Pete

 

[Elaine]

Got it to work by using =SUMPRODUCT(--(TEXT(C12:C18,"mmm")="Jul"))

 

[Dave Peterson]

or...
=SUMPRODUCT(--(month(C12:C18)=7))

or for a given year:
=SUMPRODUCT(--(TEXT(C12:C18,"yyyymm")="200807"))

 

[Elaine]

Thanks
Pete got it before I got your message, have now added the year on, working
perfectly now

 

[Pete_UK]

You're welcome, Elaine - thanks for feeding back.

Pete