| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can i use countif function inside a filtered range
How can I use countif function inside a filtered range
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how can i use countif function inside a filtered range
Hi,
Not much detail here, so this is the general idea: =SUMPRODUCT(SUBTOTAL(3,OFFSET(C13:C18,ROW(13:18)-13,0,1)),--(C13:C18="Red")) -- If this helps, please click the Yes button Cheers, Shane Devenshire "jayin" wrote: How can I use countif function inside a filtered range |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use a Reference inside a SUMIF or COUNTIF Function? | Excel Worksheet Functions | |||
| can't use function 'countif' in named range | Excel Discussion (Misc queries) | |||
| COUNTIF Function on filtered data | Excel Discussion (Misc queries) | |||
| Countif Function for dates in a range | Excel Worksheet Functions | |||
| Using a range variable inside a excel function | Excel Discussion (Misc queries) | |||
Hybrid Mode
