formulas
 

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?

formulas
 

You have to specify your range. In this example, I've specifed row 2 to 100
in the persprective column.

=SUMPRODUCT(--(A2:A100="January"),--(B2:B100=""))

HTH,
Paul


--

"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?

formulas
 

Try:

=SUMPRODUCT((A1:A20<"")*(O1:O20=""))

Adjust to you own ranges

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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?

formulas
 

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?