Using countifs for multiple criteria

Emily S
Emily S ✭✭
edited 06/23/22 in Formulas and Functions

I have used the following which results in 'unparseable'. What's wrong with the formula please?

=COUNTIFS({P&P report - AH - 15 Jun 22 Range 1},[Primary Column]@row), COUNTIFS({P&P report - AH - 15 Jun 22 Range 5}, "1"))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!