Is it possible to get a count in Sheet Summary with the following equation?

=IF([CFO Install]@row = "yes, me only", 1, IF([CFO Install]@row = "Yes, my spouse and I", 2, IF([CFO Install]@row = "Unable to attend", 0)))

I keep getting #unparseable. I tried COUNTIF(s), SUMIF(s)

Right now I have been creating a separate column in my sheet with the formula to get the sum. I would like to clean up my sheet and have this on the sheet summary.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!