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

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

--

HTH

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


"amkazen" <amkazen@discussions.microsoft.com> wrote in message
news:F366BD5C-11E7-4BF3-B396-697FA829F00D@microsoft.com...
> 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