| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embed a countif function in subtotal function?
How do I set up a formula to count only from the VISIBLE rows (Filter is on)
the cells that fulfill another condition? Ie Countif it's equal to 1, but only from the rows that are visible? Thank you very much, Dan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Embed a countif function in subtotal function?
Try...
=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A10,ROW(A2:A10)-ROW(A2),0,1)),--(A2:A10= 1)) Hope this helps! In article , "Stuck at work" <Stuck at wrote: How do I set up a formula to count only from the VISIBLE rows (Filter is on) the cells that fulfill another condition? Ie Countif it's equal to 1, but only from the rows that are visible? Thank you very much, Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf Function Help Needed | Excel Worksheet Functions | |||
| How do you ignore hidden rows in a countif() function | Excel Worksheet Functions | |||
| Subtotal function | New Users to Excel | |||
| Subtotal And Countif | Excel Discussion (Misc queries) | |||
| hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions | |||
Linear Mode
