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

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





Elaine wrote:

Got it to work by using =SUMPRODUCT(--(TEXT(C12:C18,"mmm")="Jul"))
--
Thanks for your support
Elaine

"Mike" wrote:

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

"Elaine" wrote:

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
--
Thanks for your support
Elaine

--

Dave Peterson