SUMIFS with sheet reference

I've read multiple posts and articles but something just isn't work in my SUMIFS formula.

I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row).

Any help would be greatly appreciated.

Find more posts tagged with

Formulas

Sheet Summary

Cell linking

Accepted answers

Sam_Harwart

Try this. When referencing another sheet, you don't need to use the referenced range twice. It's just {range} not {range}:{range}.

=SUMIFS({SPosts}, {Type}, "Social", {Team}, Label@row)

Does that work?

All comments

Sam_Harwart

Hi @Jaime Ciabattoni,

Is Label a Sheet Summary value? If so, those are referenced with "[Label]#", not the "Label@row".

Jaime Elizabeth

@PCG Sam Harwart,

When I copy the formula into the rows above the one selected in the screenshot, I want the value for that part of the formula to reference whatever value is in the "Label" column for that row (Note: The column name is not showing in my screenshot.)

For example in the row the formula lives in, it should Sum any that have "Janean" listed in the Team column of the referenced sheet. In the first row of the screenshot, it would add anyone with "Chelsea" listed in the Team column.

~Jaime

Sam_Harwart

Try this. When referencing another sheet, you don't need to use the referenced range twice. It's just {range} not {range}:{range}.

=SUMIFS({SPosts}, {Type}, "Social", {Team}, Label@row)

Does that work?

Jaime Elizabeth

That did it! I swear I tried that but Murphy's Law. :)

Thank you!
~Jaime

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.