Sumproduct help

[Keibri]

Hi guys,


Hope all is well. if it is not an inconvenience can someone please assist me with the attached file.

Basically, my workbook consists of 2 sheets.

I have 'Sheet 1' which contains 3 columns: Class, Amount, Criteria
-Class: Assets
-Amount: EUR 200
-Criteria IFRS

I would like to create a formula in Sheet 2 which sums the amounts for each class according to criteria.

E.g. It sums all assets which fall under IFRS.
It sums all liabilities which fall under IFRS etc

For convenience I have attached the file


Appreciate a lot your kind help!

Thanks

keibri

[BadlySpelledBuoy]

That's a very small sample for your exact need to be obvious.
Could you show us your expected results?

BSB

[avk]

instead of sumproduct use sumifs formula. In sheet2. position "E2"

Please Login or Register  to view this content.

in "F2"

Please Login or Register  to view this content.

[Keibri]

Hi guys,

thanks for your reply:

Kindly find a larger sample to what I would like to achieve.

Thanks a lot for your help!!

Thanks

Keibri

[AliGW]

In E2 copied across and donw:

=IFERROR(SUMIFS(Sheet1!$C$1:$C$43,Sheet1!$A$1:$A$43,Sheet2!$A2,Sheet1!$E$1:$E$43,Sheet2!E$1),"")

[Keibri]

Cheers AliGW tried your solution and solved it out great Thanks a lot!

[AliGW]

You're welcome! However, it's not really any different to what AVK suggested in post #3, so he deserves some credit, too.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Keibri]

Cheers also tried that solution! Thanks to all guys