Help with SUMIF formula
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?
Help Article Resources
Check out the Formula Handbook template!