Using AND with IF to check two text fields

Hi All,

I am trying to create a formula in a sheet that references a range from another sheet to work out IF 2 text conditions are true but not sure of the syntax. Can I get some help please with my attempt below;

Range 1 is a single select drop down using text

Range 2 is a single select drop down using numbers 0-10

I want to count the number of rows where "Account Creation" is selected with a Score of "10"

=COUNTIF((AND({Sales_Backlog_Snapshot_2402 Range 1} "Account Creation", {Sales_Backlog_Snapshot_2402 Range 2} "10'")))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!