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
Bookmarks