ironbucket1
New Member
- Joined
- Jan 5, 2022
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hello!
I want a formula that finds the item with the largest sum, for example:
Ball 2
Plate 3
Knife 1
Fork 3
plate 2
knife 2
ball 6
So in this case the formula would show me *Ball* because the sum is 8 and is the highest sum.
I know I can use sumIF, but I wonder if its possible for a formula to just find the item with the highest Sum without having to refer to something other than highest sum.
Right now I'm using *sumif* on each item and then Max/large on those cells, and that works but if a new item comes on the list I have to do another cell with *sumif*.
I prefer to do this without VBA-coding.
Can someone please help me with this?
I want a formula that finds the item with the largest sum, for example:
Ball 2
Plate 3
Knife 1
Fork 3
plate 2
knife 2
ball 6
So in this case the formula would show me *Ball* because the sum is 8 and is the highest sum.
I know I can use sumIF, but I wonder if its possible for a formula to just find the item with the highest Sum without having to refer to something other than highest sum.
Right now I'm using *sumif* on each item and then Max/large on those cells, and that works but if a new item comes on the list I have to do another cell with *sumif*.
I prefer to do this without VBA-coding.
Can someone please help me with this?