Results 1 to 16 of 16

Calculate cumulative sums and obtain highest value based on it

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2020
    Location
    Colombo, Sri Lanka
    MS-Off Ver
    2019
    Posts
    18

    Post Calculate cumulative sums and obtain highest value based on it

    Hello,

    In my large data table with many columns, I have a column for "Month", "Agent" and "Data".

    I also have two separate cells located outside the table: H1 (which will have values entered like "2018"), and J1 (which will have values entered like "JAN").

    In the table, the month column has values like "2019 JUN" (for all periods from 2012-2020), the "Agent" column has names of people (duplicated for each month), and the "Data" column has a number.

    I want to get the highest cumulative sum of "Data" based on the totals of each individual, and which agent achieved that highest total, IF two separate cells (H1 and J1) match part of the content in the corresponding "Month" column.

    The agent name "TOTAL" should be completely ignored.

    Please see the attachment, as it gives a clearer picture.

    Thank you for any help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match criteria (year) and obtain averages and sums
    By student789 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-05-2019, 03:12 AM
  2. [SOLVED] Calculate cumulative sum based on index value
    By jonnyhtfc90 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2019, 09:08 AM
  3. need help with excel formula to calculate based on cumulative
    By zr3cool in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2018, 03:36 PM
  4. Calculate sums based on date range
    By konbanwa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2017, 02:42 PM
  5. Calculate multiple cells sums based upon another cell
    By swiftworks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2013, 11:44 AM
  6. [SOLVED] Cumulative sums
    By kipronopaul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2012, 08:21 AM
  7. Replies: 6
    Last Post: 05-23-2008, 01:46 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