Re: Calculate totals for a range of names
- From: "Don Guillett" <dguillett1@xxxxxxxxxxxxx>
- Date: Tue, 6 May 2008 18:24:56 -0500
What about my answer to your previous post did NOT work?? You need to show examples of the correct answer for a couple of your donors. Either I don't understand or you are NOT explaining yourself well.
=IF(SUMPRODUCT(--(LEFT($a$3:$a$3333,3)="abb"),$b$3:$b$33)<1600,"",SUMPRODUCT(--(LEFT($a$3:$a$3333,3)="abb"),$b$3:$b$3333))
In this case LIN would show 1900
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"t_perkins" <tperkins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:31286C96-221E-474F-A268-7BE43DF6E424@xxxxxxxxxxxxxxxx
Still hunting for a solution to a problem posted earlier. I have a data
table that contains a list of donations, with the name of the donor in column
A and the amount of each donation in column B. Some donors gave more than
once, and I need to be able to calculate their aggregate donations. In the
end, I'm only interested in displaying totals for donors who gave more than
$1,600 -- whether through a single donations, or multiple donations. I want
to display the totals in column C.
What formula will allow me to calculate totals for all donors, including
names that are similar but not exact matches (e.g., grouping PERKINS JOHN W
together with PERKINS JOHN), and then show totals *only* for donors whose
total donations exceed $1,600?
Here's some sample data -- in my actual data table, there are thousands of
rows, and donors have given anywhere from one to ten or more times. As you
can see, the names aren't always entered the same way. My early research
indicates that I should maybe use the LEFT function to compare the beginning
characters of names, but please tell me if there's another way.
A B C
Contributor Name Amount Over 1,600?
ABBOTT DOROTHY C 1500
ABBOTT DOROTHY C 15
ANDREWS KATE 100
ANDREWS KATE J 50
BROWN MICHAEL 25
DALTON KUMI 1400
FRENCH KATE K 1550
FRENCH KATHERINE K 100
GORDON NANCY 10
LINCOLN EDDIE 25
LINCOLN ELLEN 25
LINCOLN ELLEN M 1000
LINCOLN ELLEN M 800
LINCOLN ELLEN M 50
.
- Follow-Ups:
- Re: Calculate totals for a range of names
- From: t_perkins
- Re: Calculate totals for a range of names
- References:
- Calculate totals for a range of names
- From: t_perkins
- Calculate totals for a range of names
- Prev by Date: Re: Force excel to read dates as D/M/YYYY
- Next by Date: Re: How do I set up a formula to add column a if column b = cell c1?
- Previous by thread: Calculate totals for a range of names
- Next by thread: Re: Calculate totals for a range of names
- Index(es):
Relevant Pages
|
