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
Where D9:P9 are sheet names, C3:C87 is the criteria range, H3:H87 is the sum range
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
If all the sheets are the same layout, you could maybe create a Pivot Table with multiple data sources.
You can however nest multiple SUMIF formula within one formula:
=SUMIF(CriteriaRange1,Crit
Alternative do multiple SUMIFs in a column and then add them up.