Closed Thread
Results 1 to 2 of 2

Sort multiple columns (for years of donations) to find single year donors (in rows)

  1. 05-26-2016, 08:40 PM #1
    ACCESKenya
    ACCESKenya is offline
    Registered User
    Join Date
    05-26-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    Mac 2011
    Posts
    2

    Sort multiple columns (for years of donations) to find single year donors (in rows)

    Hi there,

    I'm new to this forum, and a basic user of Excel, working for a non-profit. I tried to find my situation in the forum threads, but wasn't able to. I'm trying to take the last five years of donors/donations and sort them into one time, two time, etc. donors.

    I need to calculate how many one-off donations we've had, and the total amount they've donated for each year. I have one column with the donor name, and five additional for the years I need to quantify.

    There are nearly 800 rows of names/donations and doing it manually isn't going to work...

    Any help would be greatly appreciated!

    ACCESKenya
    Reply With QuoteRegister To Reply
  2. 05-27-2016, 06:54 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Sort multiple columns (for years of donations) to find single year donors (in rows)

    The formulas you will need to employ will need to be COUNTIFS() (to get a total count of how many donations exist for a single person in a specific date range, and SUMIFS() to get the $ amounts.

    For example, assuming column A is names, B is dates and C is donation amount:

    =COUNTIFS(A:A, "John Doe", B:B, ">=1/1/2015", B:B, "<=12/31/2015")
    =SUMIFS(C:C, A:A, "John Doe", B:B, ">=1/1/2015", B:B, "<=12/31/2015")


    Also, a PIVOT TABLE will do this for you automatically.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort multiple columns (for years of donations) to find single year donors (in rows)
    By ACCESKenya in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2016, 03:59 AM
  2. need help!! sort multiple rows into single column
    By dani_koentz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2016, 05:04 AM
  3. [SOLVED] Smart Sort, Single To Multiple Columns
    By ejoneslor in forum Excel General
    Replies: 5
    Last Post: 10-19-2015, 06:16 AM
  4. how to copy/past data from multiple rows/columns to multiple columns one single row?
    By giovanna1 in forum Excel General
    Replies: 9
    Last Post: 12-15-2013, 10:05 PM
  5. Transpose copy paste multiple columns of a single row to a multiple rows in a single colum
    By Maheedhar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-25-2013, 07:12 AM
  6. merging duplicate donors from different years
    By eli_ in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-12-2012, 08:44 PM
  7. Transposing data from multiple rows into single rows & multiple columns
    By eterna24 in forum Excel General
    Replies: 1
    Last Post: 03-18-2009, 04:18 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1