??? Counting Months In a Column

[Karleajensar]

In column -I- I have dates ranging several years in the "00/00/00" format. What formula do I use to count all of the Januarys, Februarys, Marches, etc in that column. As always, thanks very much for your help.

[NBVC]

Try:

=SUMPRODUCT(--(MONTH($I$2:$I$100)=1))

adjust ranges to suit....

where 1 represent January

you can change that to

=SUMPRODUCT(--(MONTH($I$2:$I$100)=Row($A1))) and copy down to get January, February, March, etc. consecutively

[Karleajensar]

Thank you!

[NBVC]

No problem!