How can I do this complicated addition in Microsoft Excel?

Question

I have a spreadsheet that consists of information about donations to an organization and the names of people who gave the donations. These two kinds of information came from different sources and are linked by an ID number. Each donor may have given more than one donation, but each ID number is identified with only one name.

For example:
Donor ID Donation Amount
1 $500
1 $400
2 $900

Donor ID Donor Name
1 John Doe
2 Mary Smith

I would like an output that sums all the donations that one person gave, like this:
Donor Amount
John Doe $900
Mary Smith $900

So what I want is a function that does this: "Scan all cells within range, and sum all of the cells within the range matching the criteria I specify."

SumIF does not do this because it will not add individual cells to the total, as far as I can tell; it will only sum the whole range if the criteria are satisfied.

Answer 1

I would create another sheet that sums by donor and then simply reference that sheet using the Vlookup function. You can then change the lookup cell to whatever name you choose and it will bring that data in.

You would have to update the reference sheet each time to make sure it is current but it should be that simple.

Answer 2

You can do this with "SUMIF"

Say you have above data (ID & amount) in A1:B3 range and you have the other table starting from A7. Then type in C7

=SUMIF ($A$1:$A$3,"= A7", $B$1:$B$3 )

$A$1:$A$3 = ID No

$B$1:$B$3 = Amount donated (Sum range)

A7 = ID no in the second table (with names)

Send me an email if this is not clear.

Answer 3

If somebody from The Geek Squad put in a duplicate of place of work ultimate, did not fee you and you have not got the unique CDs, i'm sorry to assert so yet they could probable be fired for doing so. and not using a liscense, which might come interior the $six hundred equipment, you won't be able to use place of work for greater suitable than approximately 2 months on an ordeal reproduction. That stated, whilst what you prefer to do is technically achievable, notwithstanding on no account utilising optical media because of the fact the provider between the two computers, at present no application which will do it effectively and mind-blowing. the time-honored resut of attempting to do it with immediately's modern-day courses is a corrupted deploy on the recent computing device and different important or minor issues on the recent computing device added down the line led to by utilising it, and finally you will could flow in and the two fix the wear led to by utilising it or greater probable merely fix the computing device.

Answer 4

I use =sumif as follows. I have two columns labeled date and gross. They run from row 2 to around 400.

In cell A427 I have a date to match.
In cell B427 I have the formula, =sumif(date,A427,gross)

date and gross are named ranges

It sums only the gross amounts if the associated date is equal to the date in A427. This sounds a little of what you are trying to do.

Think of date as donerid and gross as donation.