+ Reply to Thread
Results 1 to 5 of 5

Cumulative Running Totals needed for donations

  1. #1
    Registered User
    Join Date
    04-03-2015
    Location
    Preston, England
    MS-Off Ver
    2013
    Posts
    3

    Unhappy Cumulative Running Totals needed for donations

    Hi wondering if anybody can help me with the following:
    How can I get the "Analysis by Donor" table found on the worksheet "Donor Analysis" to sum by donor the amount of boxes under the different categories from the worksheet "Others". To get to this point I have had help from excelforum users.

    Pallet_issues v2.xlsx
    Attached Files Attached Files
    Last edited by Lynx4ever; 06-12-2015 at 01:06 PM. Reason: Analysis by donor needs to be on separate worksheet.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Cumulative Running Totals needed for donations

    I'd be tempted to do something like this. See columns D, E & F...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    04-03-2015
    Location
    Preston, England
    MS-Off Ver
    2013
    Posts
    3

    Re: Cumulative Running Totals needed for donations

    That's brilliant. Would never have been able to solve this. I had a look at your spreadsheet and realised that I also need a cumulative total
    running total by donor. I have inserted a blank column "Cumulative No of boxes donated by donor" (column D). How do you get it to add a running
    cumulative total by the donor name. So I guess I will need to do something with Column B "Donor" and Column C "Number of boxes donated by donor"
    Many thanksPallet Issue v1.xlsx

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Cumulative Running Totals needed for donations

    Adding to Glenn's solution: I have added a table which will list the donor names and then count the donations per pallet.
    Attached Files Attached Files

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Cumulative Running Totals needed for donations

    Here's another option that uses a Pivot table that automatically refreshes every time you activate the pivot table sheet.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to get cumulative totals from weekly totals (IE sum of all previous cells)?
    By moeburn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2013, 07:29 PM
  2. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM
  3. Replies: 1
    Last Post: 03-08-2012, 05:36 PM
  4. Cumulative totals
    By mfugate in forum Excel General
    Replies: 2
    Last Post: 08-02-2010, 07:43 PM
  5. Cumulative totals
    By sh3896 in forum Excel General
    Replies: 17
    Last Post: 10-27-2009, 02:10 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1