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.
Attempting to use SumIfs where 1 column could have multiple different values.
I have tried to find the answer by browsing through questions already submitted about sumifs but I can't seem to find a question that addresses my issue. Apologies if this has been asked and answered.
I'm attempting to sum a column based on the values in 2 other columns.
my column headers are: Sprint, Task Hours, and Stage.
I'm attempting to sum Task hours where Sprint is equal to "Sprint 2" and Stage is: "Demo Ready", "Passed Demo", or "Deployed".
This is the formula I have so far
=SUMIFS([Task Hours]:[Task Hours], Sprint:Sprint, "Sprint 2", Stage:Stage, "Demo Ready")
Once I add another stage
=SUMIFS([Task Hours]:[Task Hours], Sprint:Sprint, "Sprint 2", Stage:Stage, "Demo Ready", Stage:Stage, "Deployed")
the formula returns 0.
I can do anyone of the Stage columns by themselves and a value is returned but once I try to add a 2nd or 3rd stage description the function returns 0.
I am assuming this is because when I write (Stage:Stage, "Deployed", Stage:Stage, "Demo Ready") the function is looked for a row that has "Deployed" and "Demo Ready".
I have tried to use the OR function in conjunction with my Sumifs() but that doesn't seem to work.
Any help would be greatly appreciated.