Thread
:
formulas
View Single Post
#
3
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
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?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann