How are the months listed? Text like Jan, Feb January February?

=SUMPRODUCT(--(A2:A100="Jan"),--(TRIM(O2:O100)=""))

best would be to replace "Jan" with another cell like H1 and then put the
month there

If the months are regular dates like 01/01/07 formatted as mmm you can use


SUMPRODUCT(--(ISNUMBER(A2:A100),--(MONTH(A2:A100)=1),--(TRIM(O2:O100)=""))


where 1 would be for January, 2 for February


--
Regards,

Peo Sjoblom



"TDW" wrote in message
...
How can I calculate the number of blank cells in Column O based on
information in Column A? By counting the number of blank cells I can
figure
how many apps. I still need to receive but I would like to do this per
month
(the months are listed in Column A) Any ideas?