Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |