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

7 Replies

  • 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.

Resources