Link to home
Start Free TrialLog in
Avatar of Aamir Hussain
Aamir Hussain

asked on

How to sum Across Multiple sheets as per Criteria

HOw to sum Across Multiple Sheets as per criteria ??

Where D9:P9 are sheet names, C3:C87 is the criteria range, H3:H87 is the sum range
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Standard SUMIF or SUMIFS do not work across multiple sheets.

You can however nest multiple SUMIF formula within one formula:

=SUMIF(CriteriaRange1,Criteria,SumRange1)+SUMIF(CriteriaRange2,Criteria,SumRange2)+SUMIF(CriteriaRange3,Criteria,SumRange3)

Alternative do multiple SUMIFs in a column and then add them up.
Aamir in my formula I used C10 as your criteria lookup value, please change it where you are lookup Criteria value for Criteria range C3;C87.
Avatar of Aamir Hussain
Aamir Hussain

ASKER

Its Working Perfect :-) Thank u so much
You're Welcome Aamir! Glad I was able to assist.
Thought of another option.

If all the sheets are the same layout, you could maybe create a Pivot Table with multiple data sources.