Help with SUMIF formula

Raquel Charaba

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

@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.