Sumif one of criteria is met - or countif?

NicoleB ✭✭
edited 08/29/22 in Formulas and Functions

I have a column of data that I would like to Sum if different criteria are met -

here is an example -

Sumif = x or y or z

Sumif = a or b or c

I'm trying to Sum or count

Tried a few formulas so far

=SUMIFS({INT/EXD - Stage}, "Not Started", or [{INT/EXD

- Stage}, "IDD Started", or {INT/EXD - Stage}, "As - Is

Documentation completed")

I've also tried with Countif and moved the OR around


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!