I have attached a sample worksheet.
There is 1 data-entry sheet.
There is 12 monthly sheets.
There is 1 summarized overview sheet showing a simple count.
I want to be able to count blank cells and show it on the summarized overview.
I have attached a sample worksheet.
There is 1 data-entry sheet.
There is 12 monthly sheets.
There is 1 summarized overview sheet showing a simple count.
I want to be able to count blank cells and show it on the summarized overview.
maybe =SUMPRODUCT((JAN!I:I="")*(JAN!F:F<>""))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
sktneer, I usually don't but the OP was using almost the whole column (I2:I1048576) so I figured I'd use the whole column as a reference. But trolle can adjust the range to suit.
You can use this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks