COUNTIFS formula for criteria in two columns in another sheet not working

SarahBKarna ✭✭
edited 06/16/22 in Formulas and Functions

I am counting how many ads are live out of how many total and I'm unable to get the COUNTIFS formula to work. The cell should reference another sheet and count how many ads are live in each category.

The formula I'm using is coming up unparesable even though I referenced Smartsheet's many help pages on this topic. What am I doing wrong?

=COUNTIFS({6. Ad Placement Tracker Range 1}:{6. Ad Placement Tracker Range 1}, 1, {6. Ad Placement Tracker Range 2}:{6. Ad Placement Tracker Range 2},"eNewsletter"})

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!