Can I nest more than one SUMIF

I am trying to create a SUMIF that will evaluate three options from drop down column and return a reduced percentage sum from within another column on the same sheet.

Drop down Column - Affected Customer Impact Risk

Options - Low Impact Risk (25%), Moderate Impact Risk (50%) or High Impact Risk (90%)

Take the total amount from the # of Accounts Affected and return a reduced value total.

=SUMIF([Affected Customer Impact Risk]@row, ="Low Impact Risk (25%)", [# of Accounts Affected]@row * 0.25, SUMIF([Affected Customer Impact Risk]@row, ="Moderate Impact Risk (50%)", [# of Accounts Affected]@row * 0.5, =SUMIF([Affected Customer Impact Risk]@row, ="High Impact Risk (90%)", [# of Accounts Affected]@row * 0.9)))

I have tried using the SUMIFS as well as an OR operator but it will not calculate more than one at a time.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!