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!

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.