sum range with Index Match

[tanuxaxaxa]

Hi guys!

Would appreciate a help on this one.
I have the fundraising amount in one column and name in another one

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="129"></colgroup><tbody>[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c9daf8]#c9daf8[/URL] , align: right"]Amount[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c9daf8]#c9daf8[/URL] "]Team Members Name[/TD]
[/TR]
[TR]
[TD="align: right"]$10.00[/TD]
[TD]Anna Z[/TD]
[/TR]
[TR]
[TD="align: right"]$50.00[/TD]
[TD]Bettany B[/TD]
[/TR]
</tbody>[/TABLE]

And I need to sum up the total amoun of donations per each person in a different table.

I have fixed the Index Match to lookup a value, but do not know how to go from here to sum all the values up!

Would appreciate the help

 

[Aladin Akyurek]

One option is to run a pivot table on your data.

Otherwise, care to post the formula you have -- because that would indicate which ranges are involved?

 

[tanuxaxaxa]

One option is to run a pivot table on your data.

Otherwise, care to post the formula you have -- because that would indicate which ranges are involved?

Can't go for the pivot as I need a sum in a table which also contains unique data

In regards to the ranges -

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amount[/TD]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Name[/TD]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10$[/TD]
[TD]Donna[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Monica[/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20$[/TD]
[TD]Anna[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Anna[/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10$[/TD]
[TD]Monica[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5$[/TD]
[TD]Monica[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3$[/TD]
[TD]Donna[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have Index Match which looks like that now (as two table on dif tabs)
=INDEX(('tab1'!A:B),MATCH(C2,'tab1'!B:B,0),1)

So it works as a lookup but does not sum up naturally.


Hope that makes sense

And thanks for taking a look

 

[Aladin Akyurek]

=SUMIFS(tab1!A:A,tab1!B:B,C2)

where C2 houses a name like Monica.

The formula you posted references just one tab (sheet) though.

 

[tanuxaxaxa]

That worked!

Thank you so very much, can't believe I so overcomplicated it

 

[Aladin Akyurek]

@ tanuxaxaxa

You are welcome.