Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Can the SumIF check against multiple values instead of one?

Suzan Balaa
edited 12/09/19 in Archived 2016 Posts

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? 





This discussion has been closed.