Count a specific month in a column

  • Thread starter Thread starter Elaine
  • Start date Start date
E

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
 
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
 
or...
=SUMPRODUCT(--(month(C12:C18)=7))

or for a given year:
=SUMPRODUCT(--(TEXT(C12:C18,"yyyymm")="200807"))
 
Thanks
Pete got it before I got your message, have now added the year on, working
perfectly now
 
Back
Top