COUNTIFS for whole Sheet
This is probably an easy fix but I am having no luck.
I want to count if anywhere on a sheet has a "4" in a cell.
I also want this to separate the counts by "ITCMW", "ITCT" & "METC"
My current formula is:
=COUNTIFS([Pre Trip Completed]:[Doors/Gates], HAS(@cell, "4"))
I need to include System:System, "ITCMW" in this formula.
Help Article Resources
Check out the Formula Handbook template!