SUMIFS with sheet reference

Jaime Elizabeth · 05/07/24

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.

Sam_Harwart · 05/07/24

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?

Sam_Harwart · 05/07/24

Hi @Jaime Ciabattoni,

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

Jaime Elizabeth · 05/07/24

@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 · 05/07/24

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 · 05/07/24

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

Thank you!
~Jaime

Formulas and Functions

Formulas and Functions

SUMIFS with sheet reference

Best Answer

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Created Date of Row Copied from Another Sheet

Need to update dates to Q1_2025, Q2_2025, Q3_2025, Q4_2025

Writing a reference formula with multiple IF/AND situations