Alright, I'm sure one of your excel ninjas can figure this out pretty quickly. I'm trying to run some analysis on an organization's charitable giving from last year. I have a spreadsheet that lists every one of the 4,000 gifts made to them. Each gift has a Payer ID associated with it, so if someone gave once a month they have 12 entries scattered throughout.
I want to convert that data into a sheet that sums up each household gift total. So that 4,000 rows should turn into about 250 rows with a formula that looks through the main data and finds the 12 times Payer ID 501 is listed and adds up all the entries for him.
Been a while since I've been in excel much so I'm a little rusty. Any ideas?
I want to convert that data into a sheet that sums up each household gift total. So that 4,000 rows should turn into about 250 rows with a formula that looks through the main data and finds the 12 times Payer ID 501 is listed and adds up all the entries for him.
Been a while since I've been in excel much so I'm a little rusty. Any ideas?
