SUMIFS & COUNTIFS with 2 Criteria

Options

I'm trying to work on COUNTIFS first. It seems if I can crack one the other is pretty close.

The riddle:

=COUNTIF({Post Repair Count}, ({Domestic/Asian}, "Domestic"))

I've tried COUNTIFS with the 2nd range but seems that the criteria for range 1 is tripping me up.

{Post Repair Count} has no criteria to it. Just need to count it if criteria in range 2 are met @ROW from source sheet. This will be very similar to the SUMIFS that will follow.

Hope I am making sense. Thank you in advance

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!