Help! Formula with not blank column?

Hi SmartSheets community, I need help finishing a formula to count number of sites in a specific city/state. This is what I have so far:

=COUNTIFS({Master Data Sheet City Range}, City@row, {Master Data Sheet State Range}, State@row)

I want to make one other column next to column that has this formula that counts only if the site has an assigned number to it (to identify the site). Hope that makes sense. Help please!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!