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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting dates in filtered column 1
Subtotal of values in cells containing formula 1
Sum after Filter, Count after Fliter 2
subtotal function won't work 1
please try this 6
Macro Pause to Select range then Subtotal 0
count unique values in a filtered range 2
nested subtotal with sumproduct 0

Top