SUMIFS Across Two Sheets with Multiple Criterion

Hi All,

I am looking for a the next step of this formula, I now want to include a department filter on this SUM Formula instead of all departments? is that possible

=SUMIF({Timesheet Range 1}, =[Export Title]@row, {Timesheet Range 4}).

Timesheet Range 1= Phase Name - Sheet 1

Export Title= Phase Name - Sheet 2

Timesheet Range 4 = Total Cost - Sheet 1

NEXT Step Add This into Equation

Timesheet Range 2 = Department Name- Sheet 1

Department= "Name" - Sheet 2

Find more posts tagged with

Accepted answers

All comments

Jaykel Torres

Hey @Brendan Ginns,

Instead of using the SUMIF Function, which can only accept a single criteria, use the SUMIFS Function which works with multiple criteria. You may add the Department Range and Name criteria alongside your pre-existing criteria. I've created the example below to demonstrate this:

Formula (highlighted in yellow): =SUMIFS(Cost:Cost, Item:Item, "Apple", Type:Type, "Fruit")

I hope this helps!

Jaykel

Brendan Ginns

Hey Jaykel,

this is a great example. Do you know if this works on cross sheet formulas? Let me know

Genevieve P.

Hi @Brendan Ginns

Yes! To change this to be a cross-sheet formula you just need to adjust the column ranges.

Instead of typing Cost:Cost, you would use a cross-sheet reference, {Cost Column}

So in your instance, something like this:

=SUMIFS({Timesheet Range 4}, {Timesheet Range 1}, [Export Title]@row, {Timesheet Range 2}, Name@row)

See: Cross-sheet formulas

Cheers,

Genevieve

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.