subtotal excluding spaces ""

D

driller2

Hi again,

=subtotal(103,a2:a1000)

when i use filter "(All)" in formulated cells along column AG, the
function still has to count the "".

"" is a result of a formula.

Using the subtotal function, in a filtered mode "(All)" , I like to
count all except cells with pure space only "".

any idea..
thanks :)
 
Top