+ Reply to Thread
Results 1 to 2 of 2

Which column has the highest Total

  1. #1
    Registered User
    Join Date
    03-16-2009
    Location
    South Arica
    MS-Off Ver
    Excel 2003 & 7
    Posts
    8

    Which column has the highest Total

    Good Day

    Please can I get some help with a formula for the following question

    I have a table with 4 columns.
    I would like to find formula that sums each column then returns the column header for the column with the highest total

    I have a formula to find the highest total =MAX(SUM(G40:G49),SUM(H40:H49),SUM(I40:I49),SUM(J40:J49))
    The answer is 2.6 mil and it is the sum of range: J40:J49
    I would like the formula to return "Import"

    The headers are in row 39
    column G = Local
    column H = Regional
    column I = dummy
    column J = Import

    Thanks in Advance
    - Joe
    Last edited by JV0710; 08-30-2021 at 06:58 AM.

  2. #2
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Which column has the highest Total

    Try Formula

    HTML Code: 
    Or

    HTML Code: 
    Last edited by wk9128; 08-30-2021 at 08:14 AM.

+ 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. Replies: 3
    Last Post: 06-09-2016, 12:51 PM
  2. pivot table: adding ONE column to show % of the tota row.
    By saudi_red_neck in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-16-2014, 06:04 AM
  3. Replies: 2
    Last Post: 12-25-2012, 08:49 AM
  4. Search column for highest value, then second highest, etc.
    By MDPlanner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2010, 10:39 AM
  5. Picking the highest value from a column and then the next highest
    By johnb28 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2008, 01:20 PM
  6. Replies: 3
    Last Post: 08-10-2006, 11:40 PM
  7. [SOLVED] How do i copy numbers from Web and paste to excel and and get tota
    By jw austin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2006, 05:25 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