COUNTIF Formula referencing two columns

Options

I'm trying to get a count of sites from another sheet for City and State columns and it's not working...can someone tell me what I'm doing wrong?

Because some cities in different state have the same name, I need it to also count if the state matches. Here is my formula:

Reference Sheet - {Master Data Sheet Range City State}

=COUNTIFS({Master Data Sheet Range City State}, [Major Cities (in order by most populous to least)]@row:State@row)


=COUNTIFS({Master Data Sheet Range City State}, [Major Cities (in order by most populous to least)]@row:State@row)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!