Opposite of SUM function is ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...
add
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM Function 4
Sum Worksheets 7
How to copy the function SUM but offseted in 7 columns 2
What function is the opposite of SUM? 4
Row() and SUM() ?s 7
SUm function and adding rows 2
Conditional SUBTOTAL in XL210 Table 7
Summing a variable number of rows 3

Back
Top