| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Subtotal function
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the Subtotal function | Excel Worksheet Functions | |||
| Subtotal function not available | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| Subtotal function | New Users to Excel | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Hybrid Mode
