Countblank

A

AdamJ28

Using the function 'COUNTBLANK' on excel it doesnt want to work using i
on more than 1 sheet. I want to count singular cells on quite a fe
different worksheets, but its not happening using 'COUNTBLANK' Or wha
is it you put between each cell, i would think a , but it isnt working
can anyone help
 
P

Peo Sjoblom

You can use this workaround

=SUMPRODUCT(COUNTBLANK(INDIRECT("'"&A3:A14&"'!A2")))

where A3:A14 holds the sheet names you want to count like

Jan
Feb
Mar
etc

as an example
 
D

Dave Peterson

I think I'd just use a few =countblank() functions:

=countblank(a1:a10)+countblank(sheet2!a1:a10)
and so forth.

Or for single cells:

=SUM(B9="",Sheet2!A1="",Sheet3!A9="")
 
Top