Using Countif with IF statement

In my sheet I have a range I am counting which works fine.

For example: =countifs([range name},System@row)

Now I want to reference another range name the location which meets the entry in the row

I can't see to get the order of syntax correct.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!