Hello.
So.... I have this recurring paypal transactions. Each month I get a report.
I want to know who donated more than, let's say, $100.
But many donate $5 each month.
So I want Excel to tell me ----- hey, yeah I recognize this guy, he is the same guy from last month (and the month before), and even though he just donates $5 at a time, his TOTAL is more than $100, so here is his info.
Is this possible?
Thanks so much!
Last edited by benyben123; 11-26-2013 at 01:20 AM.
You could use SUMIF, SUMIFS or SUMPRODUCT to total his contributions.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
not sure how ):
Hi
Please upload a sample sheet
Regards
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
Ok so here is another effort to explain (sorry - it's difficult to explain this).
So each month I download a list of people who donated money to our .org.
Let's say there are 10 people each month.
The list starts from January 2013 (this year).
Now, it's November, and i want to only send a thank you letter to the people who's sum TOTAL in donation is MORE than $100.
So if JAY SMITH donated $5 each month, he actually donated more than $100 by now (November). I want to be able to know that.
Thanks a million!
....^....1
Entia non sunt multiplicanda sine necessitate
Benyben, you need to change your thread title (as requested in post # 5) before other members will off suggestions. I know this is a tough 1 to name, but maybe something like "ID repeat names and base calcs on those names"?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
So U guys mentioned SUMIF or SUMIFS but I don't know how to use these. I might be dumb when it comes to these things ):
SUMIF() and SUMIFS() are functions that let you total values based on certain criteria...
=sumif(criteria-range,criteria,sum-range_
SUMIFS() is pretty much the same except it gives you more criteria
=sumifs(sum-range,criteria1-range,criteria1,criteria2-range,criteria2,criteria3-range,criteria3.............)
See file attached as example. (I wish I could share the original but I am not allowed).
But how do I literally input it?
So let's say I only want to see the PEOPLE who's TOTAL donation were ABOVE $29.
Plz help!
Thanks a million
Looks like a Pivot Table is what you need. Select any cell in the data area. Choose Insert | Pivot Table.
Drag the name to the rows and the amount to the values. Make sure it is summing and not counting.
Regards, TMS
Thx so much for that!
Ahhh.... what now?
I mean - how do I ONLY show those who donated above X?
See attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks