Having Issues with COUNTIFS function

Shawn R
Shawn R ✭✭
edited 12/09/19 in Formulas and Functions

I have a sheet in which I reference another. What I am trying to do is reference two columns from one sheet to count the amount of entries that match the logical expressions.

Here is my current formula.

 

=COUNTIFS({Copy of Incident Report Range 1}, "Burn", {Copy of Incident Report Range 5}, 1)

 

What I want the column to do is count how man entries from Range 1 are equal to "burn". Additionally I have a column that's a checkbox column which is the second Range I am referencing in the above formula.

So my end goal would be to count how many rows have both "burn" and the column is checked. If I create both these formula separately in two different columns they work. But when I combine them they return INCORRECT ARGUMENT SET.

Makes me wonder if this is possible. Any help would be appreciated.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!