Help with SUMIF formula
Hi everyone,
Can you help me to figure out what is the correct formula to use in this case?
I want to sum only the rows that have the following criteria: "Projected" or "General Foreman", or "Foreman". I don't want to sum up the other rows.
The formula I was using to sum only projected was this one: =SUMIFS([Mon, 17, Apr]1:[Mon, 17, Apr]42, $TASK1:$TASK42, "Projected")
How can I add the other 2 criteria to this formula?
Thank you!
Answers

You can use the following: =SUMIFS([Mon, 17, Apr]1:[Mon, 17, Apr]42, $TASK1:$TASK42, OR(@cell = "Projected", @cell="General Foreman", @cell= "Foreman")
This will sum anything in the Mon, 17, Apr column where the task is one of your values.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Help Article Resources
Categories
Check out the Formula Handbook template!