Function similiar to sumproduct

[An06]

Hi.
Need your help.
Attached you can find the requested function sheet.
I need to get the volume of transactions for two groups of countries, but it is necessary to add up the receipts and transfers from individuals and legal entities and get one number for each group.
Thanks in advance


Task.xlsx

[samba_ravi]

Try below formula
=SUMPRODUCT(SUMIFS(Transactions!B$3:B$251,Transactions!$A$3:$A$251,'Risk Level'!$A$2:$A$250)*('Risk Level'!$B$2:$B$250=$A1))

[AliGW]

Your 'needed function' tab has NO expected results.

I hope this isn't a repeat of the previous question you asked. Please make sure that your 'friend' does not come and ask the same question in another thread. If they do, they will be banned from posting here. Thank you.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[TMS]

Try this, copied down:

Please Login or Register  to view this content.

[TMS]

Updated file attached.

[Phuocam]

Or try:

Please Login or Register  to view this content.

[An06]

I tried this one, but it didn't work

[An06]

This one is very long version, can we have the short one of the function?

[An06]

Its seems you consider only one column, but I need to sum all columns of transaction sheet and getting one number from them

[TMS]

All the formulae work for me. See attached.

[An06]

I tried this formula but it showed me spill and didn't work, Could you help?

SUMPRODUCT((Transactions!B$3:B$251+Transactions!D$3:D$251+Transactions!C$3:C$251+Transactions!E$3:E$251)*(VLOOKUP(Transactions!$A$3:$A$251,'Risk Level'!$A$2:$B$250,2,FALSE)=$A1))
I just correct one point, as I need to sum all incomes and outcomes

Kindly ask you to explain me how it works.
I need to bring the data from one sheet, to sum up 4 columns according to their risk level group country, so at the end I want to have 2 group data transactions combined from entities and individuals and sum all outcomes and incomes.

[JohnTopley]

The file in post #10 provides ALL the sums required so no idea what else you require (other than SUM A&B and C&D in "Needed Function"?)

Column K in attached has formula from your last post.