formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
 
Back
Top