COUNTIF / SUMS where distinct Criteria is MET

[rz6657]

I've doing the count/sum manually all of 2019 as I haven't been able to figure out how to automatically count / sum each distinct criteria.

There are 3 different sets and each one differs. I tried using the COUNTIF and SUMIF but I've not been successful. In the attached file, I've outlined each criteria for each row in the Status tab that counts / sums from the Working Detail tab (this data is dynamic and having to count/sum daily is tiresome). The current count/sum in the table is what I'm trying to achieve for today's exercise. Thanks in advance...