Using Subtotal function

U

Usman Meer

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?
 

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

Getting Text data using the Data - Subtotal feature 1
Display Multiple Cells when Using Subtotal Function 0
Macro Pause to Select range then Subtotal 0
create a consolidated text list from multiple ranges 0
Subtotals 2
SUBTOTAL QUERY 5
subtotal filter with growing range 2
Subtotal counting formula in cells 1

Top