| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested --- Subtotal IF function
How do I do this?
I'm using autofilter to hide rows that = 0. to get the total I have Subtotal (9, D2:D50) Now I need to count if column A = A1 COUNTIF(A2:A50, A1) The only problem w/ the above is that it counts the hidden rows. How do I count only the visible rows? Thanks in advance. Lisa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF with OR Function | Excel Worksheet Functions | |||
| Subtotal function for hidden row | Excel Worksheet Functions | |||
| Several function questions (nested functions) | Excel Worksheet Functions | |||
| Nested if, sum & vlookup Function | Excel Worksheet Functions | |||
| Why is the subtotal function in excel 2003 very slow compared to . | Excel Worksheet Functions | |||
Threaded Mode
