View Single Post
  #1   Report Post  
driller2 driller2 is offline
Junior Member
 
Posts: 27
Thumbs up subtotal excluding spaces ""

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

--
regards
driller2