ExcelBanter - Opposite of SUM function is ??

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Opposite of SUM function is ?? (https://www.excelbanter.com/excel-discussion-misc-queries/22477-opposite-sum-function.html)

amkazen

Opposite of SUM function is ??

Hi, I found a post from 2/23/05 titled "Sum of Max cells in a range". I want
the difference, not the sum. Anybody know what the function that is opposite
SUM is? Thanks.

=SUMPRODUCT(LARGE(A4:T4,ROW(INDIRECT("1:3")))) I want to subtract, not add

Bob Phillips

=MAX(A4:T4)-SUMPRODUCT(LARGE(A4:T4,ROW(INDIRECT("2:3"))))

--

HTH

RP
(remove nothere from the email address if mailing direct)

"amkazen" wrote in message
...
Hi, I found a post from 2/23/05 titled "Sum of Max cells in a range". I
want
the difference, not the sum. Anybody know what the function that is
opposite
SUM is? Thanks.

=SUMPRODUCT(LARGE(A4:T4,ROW(INDIRECT("1:3")))) I want to subtract, not
add

All times are GMT +1. The time now is 05:35 PM.