Forum Discussion
SUBTOTAL Filtered Text
Need SUBTOTAL or other formula for count Filtered & Visible text and date (don't want to count "0" or "-")
Filter time total value not showing proper value.
| MSN No | Visit Plan | Visit Date |
| PAINT-R02 | 05-Dec-18 | 05-Feb-19 |
| PC-AS-R03 | 23-Apr-19 | Not done |
| GIA-CC-RT-08 | 28-Nov-18 | Not done |
| GIA-CC-RT-04 | 28-Nov-18 | Not done |
| GIA-CC-RT-13 | 28-Nov-18 | Not done |
| GIA-CC-RT-07 | 28-Nov-18 | Not done |
| GIA-CC-RT-02 | 28-Nov-18 | Not done |
| GIA-CC-RT-03 | 28-Nov-18 | Not done |
| GIA-CC-RT-12 | 28-Nov-18 | Not done |
| GIA-CC-RT-10 | 28-Nov-18 | Not done |
| GIA-CC-RT-09 | 25-Dec-18 | Not done |
| GIA-CC-RT-01 | 25-Dec-18 | Not done |
| GIA-CC-RT-08 | 25-Dec-18 | Not done |
| GIA-CC-RT-06 | 25-Dec-18 | Not done |
| GIA-CC-RT-14 | 25-Dec-18 | Not done |
| Service Done | 014 | |
| Service Not Done | 146 |
Hi
Could you clarify what result you are trying to obtain. It’s not clear to me sorry.
Could you clarify what result you are trying to obtain. It’s not clear to me sorry.
Wyn HopkinsI need Sum or Count "Not Done" word when applying Filter
I would add a helper column using AGGREGATE to switch between 1 and 0 when a filter is applied. Then you can use a COUNTIFS to reference that column in addition to the Not Done column