COUNTIF for Multiple Criteria

Options

Hello,

I'm trying to use the COUNTIF function to pull a total number from three different columns. Each total would need to include the criteria word for the three columns to be counted. The formula works until I add the third criteria and then it takes the total down to 0. I'm not getting an error, however. Can someone provide insight on what I'm doing wrong? Should I have an AND in there somewhere?


=COUNTIFS({Campaign Request Intake Range 1}, "Email", {Campaign Request Intake Range 4}, "LATAM", {Campaign Request Intake Range 5}, "Paula")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!