I have two colums and want to add up the values in column A, except the one number that corresponds to the maximum in colum B.
So for example
1 3
5 7
6 9
4 1
3 3
I would like excel to add up 1 + 5 + 4 + 3 (and not add 6 as 9 is the maximum in colum B). I have 163 rows so nesting is not possible.
Any solutions? I've been wrecking my head...
So for example
1 3
5 7
6 9
4 1
3 3
I would like excel to add up 1 + 5 + 4 + 3 (and not add 6 as 9 is the maximum in colum B). I have 163 rows so nesting is not possible.
Any solutions? I've been wrecking my head...