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!



  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭

    @Raquel Charaba

    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.

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!