SUBTOTAL Filtered Text

[Kudkuli_B_Raghu]

Need SUBTOTAL or other formula for count Filtered & Visible text and date

(don't want to count "0" or "-")

[#2]

Could you post a quick example file or picture. if this sort of thing isn't what you need...

=COUNTIFS(A1:A100,"<>0",A1:A100,"<>"&"-",A1:A100,"<>")

[#3]

@Wyn Hopkins 

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

[#4]

@Kudkuli_B_Raghu 

Where filter is applied, where is the time in the sample (dates only), what is current formula for totals, for which columns ignore 0 and "-" ?

[#5]

Hi

Could you clarify what result you are trying to obtain. It’s not clear to me sorry.

[#6]

@Sergei Baklan   I need Sum/count Not Done when filter apply

[#7]

@Wyn HopkinsI need Sum or Count "Not Done" word  when applying Filter

[#8]

@Kudkuli_B_Raghu 

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