Hi all,
Having an issue returning the maximum value of "groups" summed by certain criteria. Tried multiple variations of index, match and array formulas but have had no success yet. Stripped down the data is:
A 100 A 200 B 100 A 100 B 50
I want in 1 cell for it to work out the sum values of A & B are respectively 400 and 150 each and then return 400 as this is the highest value. Limitations:
- I don't want to filter/re-arrange or change the table in any way as the actual data set is much more complicated.
- I also don't want to directly refer to "A" or "B" with IFs or SUMIFs because the actual data set has 100+ variations
- Would prefer not to use coding as I'm terrible with it.
Any help would be greatly appreciated!
Bookmarks