# Sort and tally Multiple Entries

1. ## Sort and tally Multiple Entries

Hey Everyone,

I'm pretty new to macros and I need to tally recurring entries from a Paypal export by the name to new column for a mail merge for end-of-year donation receipt.

Most donors give a monthly amount and I want to be able to give a total amount in the letter. So the new columns would have the unique name and the total amount of donations by that person.

Any help is much appreciated!

2. ## Re: Sort and tally Multiple Entries

.
This is one method :
``Please Login or Register  to view this content.``

3. ## Re: Sort and tally Multiple Entries

Not really sure how you want it, so only my guess...

C1: enter formula
=IF(COUNTIF(A\$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"")

then copy down...

4. ## Re: Sort and tally Multiple Entries

Thank You!

That solves the amount is there a similar formula to isolate the name so when I do the mail merge not every line gets an entry?

5. ## Re: Sort and tally Multiple Entries

A formula that will produce a list of distinct names is:
Formula:
`Please Login or Register  to view this content.`

Let us know if you have any questions.

6. ## Re: Sort and tally Multiple Entries

I'm not sure I understand. When I paste the formula anywhere in the C column I get the content in A1. I'm looking to get one donor and the total amount they donated . So I need to get A1-A9 which are all the same donor into one cell next to a cell that totals B1-B9. The spread sheet is has a few thousand entries

Do I need to adjust this for each cell or Am I missing something?

Thanks

7. ## Re: Sort and tally Multiple Entries

I was using the file attached to Logit's post (#2) and putting the formula into cell F2 then dragging the fill handle down.
If you want to use the formula in column C then F\$1:F1 will need to reference the cell that is above the first cell containing the formula.
For example if the formula is pasted into cell C2 the formula should read: =IFERROR(IF(MATCH(0,INDEX(COUNTIF(C\$1:C1,A\$2:A\$100),,),)>COUNTA(A\$2:A\$100),"",INDEX(A\$2:A\$100,MATCH(0,INDEX(COUNTIF(C\$1:C1,A\$2:A\$100),,),))),"")
Let us know if you have any questions.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1