SUMIFS formula
Options
sanchezf
✭✭✭✭✭
I'm trying to find the total amount of RAID issues in a column. And get the sum of the total in my summary section but I can't figure out what I'm doing wrong with the formula.
Answers

=COUNTIF([CRAID Type]:[CRAID Type], "Action")
=COUNTIF([CRAID Type]:[CRAID Type], "Decision")
=COUNTIF([CRAID Type]:[CRAID Type], "Risk")
You mention SUMIFS. SUMIFS will sum the contents of cells matching the criteria, while COUNTIF will provide the number of cells matching the criteria.

Thank you! I knew it was something simple.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!