Using Countif with IF statement

Jacque Hale

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.

Paul Newcome

I'm not sure I follow. Are you able to provide some screenshots for reference?

Jacque Hale

Thank you , but I finally figured it out.