OR in SUMIF function

Hello,

I am trying to use OR in SUMIF function as below but get invalid operation error:

=SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]83) + SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]84)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!