Sumif one of criteria is met - or countif?

NicoleB

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

Mike TV

@NicoleB

=COUNTIFS({INT/EXD - Stage}, OR(@cell = "Not Started", @cell = "IDD Started", @cell = "As - Is Documentation completed"))

Mike TV

@NicoleB

=COUNTIFS({INT/EXD - Stage}, OR(@cell = "Not Started", @cell = "IDD Started", @cell = "As - Is Documentation completed"))

NicoleB

no - I get #unparseable

Tried it again and it worked! Thanks