May I please get assistance with a formula? I am trying to do a formula that references another sheet (Loaner Sign Out Sheet), which calculates a total from that onto my Request Metrics sheet. Please see attached. I would like a total count for Request Type "HDMI" only if the Status states "In Progress." If it's not in progress I do not want it to count towards the total.
In the example attached the total should = 1 since there's only one HDMI in a "In Progress" status.