Can the SumIF check against multiple values instead of one?

Suzan Balaa

I need to sum up a column if the value of another column is equal to EITHER X or Y.

 

I was able to write the formula to check against 1 value but I want it check against mutliple values.

 

=SUMIF([Hours]1:[Hours]10, Org104:Org110, "X")

 

I want it to become :

 

=SUMIF([Hours]1:[Hours]10, Org104:Org110, "{X", "Y"})

 

Is this possible in smartsheet and if so how would the syntax be? 

 

Thanks!

Brett Evans

Try sumifS

=SUMIFS([Hours]1:[Hours]10,  X, Org104:Org110, Y )