Sumif with criteria across sheets with a weight multiplier

[MSO_user]

Dear Friends

I kindly and humbly request, if any of you have the time to solve my query.

Please find the attachment. The formula....

=SUMPRODUCT((SUMIF(INDIRECT("'"&$I$6:$I$8&"'!"&"C5:C15"),C6,INDIRECT("'"&$I$6:$I$8&"'!"&"D5:D15"))))

applied SUMIF formula across multiple sheets and then sum the item based on a criteria using SUMPRODUCT.

My query is simple, I want to get the sum of the quantities to be multiplied by a weight no.

I have also explained the resultant value which I need, please review the snaps in series as per attachment.

Please review my sheet and help me in this regards. Any improvement in the previous code will be more than welcome.

Much Much Thanks for your support and time.....

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sumif with criteria across sheets with a weight multiplier
and Sumif with criteria across sheets with a weight multiplier

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[MSO_user]

Dear Sir [B]Fluff[/B]

Noted. I am also asking the query with my office IT staff.

So, yes indeed. If I get the solution to my answer, then I shall humbly share it.

Thanks for your support in this regards.

 

[MSO_user]

Dear Sir [B]Fluff[/B]

Thanks for your guidance....I shall comply.....

The solution to this problem is provide by kvsrinivasamurthy ..... I pray for his health and safetyhttps://www.excelforum.com/members/234305.html

Link to the solution......

Thanks for your support in this regards.....

 

[MSO_user]

Dear Fellows

It took me some time....but I have understood the issues....and again thanks to ...kvsrinivasamurthy .....otherwise I would at zero....

There was an issue with the original solution....when we delete the items in the sheet list, then the we get errors in the formulae, in order to resolve the issue, we have to update the formulae. And the formulae starts working correctly...

I order to avoid changes in the original formulae...A unique list with zero weights should be added... so that when we modify the sheet list....we do not get errors.....this way we do not have to change the formulae....

I am posting the original file (ending with (1)) and...posting the updated solution file (ending with (3))

I hope that this work shall help others as well....since it has helped me alot......indeed a lot....

Also I shall be sharing this solution with other forum members as well...

Much thanks and Much prayer for all of you guys.......

please download form the link below.....

sumif & criteria accross sheets with a multiplier (1)

sumif & criteria accross sheets with a multiplier (3)