Hi,
I am using Subtotal function like
Subtotal (3, B4:B99).
Now the range B4:B99 contains formula from some other work book and results
as "Done", "Dates" and "Blanks". The blank cells are displayed blanks but
actually they contain functions and when I count the range (using subtotal)
these blank cells are also counted. I want to ignore these blank cells in
subtotal function.
Can some one help me pleawe?