Forum Discussion

Kudkuli_B_Raghu's avatar
Kudkuli_B_Raghu
Copper Contributor
Nov 09, 2019

SUBTOTAL Filtered Text

    Need SUBTOTAL or other formula for count Filtered & Visible text and date (don't want to count "0" or "-")
office 365
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Nov 10, 2019
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,"<>")
  • Kudkuli_B_Raghu's avatar
    Kudkuli_B_Raghu
    Copper Contributor
    Nov 10, 2019

    Wyn Hopkins 

     

    Filter time total value not showing proper value.

    MSN NoVisit PlanVisit Date
    PAINT-R0205-Dec-1805-Feb-19
    PC-AS-R0323-Apr-19Not done
    GIA-CC-RT-0828-Nov-18Not done
    GIA-CC-RT-0428-Nov-18Not done
    GIA-CC-RT-1328-Nov-18Not done
    GIA-CC-RT-0728-Nov-18Not done
    GIA-CC-RT-0228-Nov-18Not done
    GIA-CC-RT-0328-Nov-18Not done
    GIA-CC-RT-1228-Nov-18Not done
    GIA-CC-RT-1028-Nov-18Not done
    GIA-CC-RT-0925-Dec-18Not done
    GIA-CC-RT-0125-Dec-18Not done
    GIA-CC-RT-0825-Dec-18Not done
    GIA-CC-RT-0625-Dec-18Not done
    GIA-CC-RT-1425-Dec-18Not done
    Service Done 014
    Service Not Done 146
    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Nov 10, 2019
      Hi

      Could you clarify what result you are trying to obtain. It’s not clear to me sorry.
      • Kudkuli_B_Raghu's avatar
        Kudkuli_B_Raghu
        Copper Contributor
        Nov 10, 2019

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

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 10, 2019

      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 "-" ?

Resources