I understand thatthis is an array but it appears to be only looking at the
month and not the year. Is this right?

"muddan madhu" wrote:

try this

for choice A
=COUNT(IF($A$2:$A$6="X",IF(MONTH($C$2:$C$6)=row(1: 1),)))

and drag it down


for choice B
=COUNT(IF($B$2:$B$46="X",IF(MONTH($C$2:$C$6)=ROW(1 :1),)))

and drag it down





On Oct 10, 7:11 pm, Bigfoot17
wrote:
A B C
ChoiceA ChoiceB Exp.Date
X 11/2/08
X 12/4/08
X 3/15/09
X 5/17/09
X 2/28/09
X 10/10/08

I have something similar to the above except with 2500 rows. I am looking
to have on a second sheet a count of the number of ChoiceAs and the number of
ChoiceBs that expire for each month of the year.

ChoiceA ChoiceB
Jan
Feb
Mar
April
...

(To complicate matters I have a spinner for the year so you can change the
2008 to 2009 and see the expirations in 2009).