Thread: formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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?