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>

Amount	Team Members Name
$10.00	Anna Z
$50.00	Bettany B

<colgroup><col style="width: 100px"><col width="129"></colgroup><tbody>
</tbody>

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 -

A	B					C	D
Amount	Name					Name	Total
10$	Donna					Monica	?
20$	Anna					Anna	?
10$	Monica
5$	Monica
3$	Donna

<tbody>
</tbody>

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.