LinkBack URL
About LinkBacks
Hi All, i was wondering if someone could help, is there a way of counting how many cells are blank if the blank is being created by a formula, the cells i'm trying to count are not contiginous either.
thank you in advance.
Hi All, i was wondering if someone could help, is there a way of counting how many cells are blank if the blank is being created by a formula, the cells i'm trying to count are not contiginous either.
thank you in advance.
Did you try...
=COUNTBLANK(A1:A100)
HTH
Regards, Jeff
That wont work for me as the cells are need to count are every 3 along for example, column D1,G1,J1,M1, i know i could use countblank(D1)+COUNTBLANK(G1) but its just far to long as there is around 35 cells to check and was wondering if there was a shorter way,
Here, try this:
=SUMPRODUCT(--(D1:M1=""),--(MOD(COLUMN(D1:M1),3)=1))
Never use Merged Cells in Excel
@ zbor
Works perfectly, thank you.
Last edited by Cutter; 10-15-2012 at 05:05 PM. Reason: Removed whole post quote
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks