Sumif one of criteria is met - or countif?

Options
NicoleB
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


thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!