ExcelBanter - subtotal excluding spaces ""

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - subtotal excluding spaces "" (https://www.excelbanter.com/excel-worksheet-functions/245309-subtotal-excluding-spaces.html)

driller2

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

All times are GMT +1. The time now is 01:53 PM.