Hi all,
Long time lurker here - can usually work things out (just about) but stuck on this one! I have searched the forum (and others) but no joy.
I want to get the sum of a column but only of those values that are the largest in their row.
A 1 1 2 1
B 1 5 1 1
C 1 6 1 1
D 1 1 5 1
Total 0 11 7 0
In this example the total at the bottom is what I want to be able to work out automatically for a larger dataset.
I hope this is clear!
Thanks
Bookmarks