formulas

T

TDW

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

PCLIVE

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
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
P

Peo Sjoblom

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
 
Top