| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal on Autofilter with Countif
Can this be done, I already have the formula to provide me a count on text
when a column is filtered, the bad thing is that I need it to not count a cell if it's a Zero. This is the formula I have =SUMPRODUCT((SUBTOTAL(3,OFFSET(F$6,ROW(F7:F1001)-ROW(F6),,1)))) Now, on that range F7:F1001, The label is March, I need to analyze inventory turns by company on an item, so If I filter the company to say Dell, I want to see the items and how many turns as a total we had in March, but it's counting Zeros too. Can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter with Subtotal Sumif | Excel Worksheet Functions | |||
| COUNTIF Subtotal Function? | Excel Discussion (Misc queries) | |||
| countif for only visible rows when combined with autofilter - possible? | Excel Discussion (Misc queries) | |||
| How do I use COUNTIF in a SUBTOTAL function to differentiate the . | Excel Worksheet Functions | |||
| Subtotal And Countif | Excel Discussion (Misc queries) | |||
Threaded Mode
