View Single Post
  #1   Report Post  
amkazen
 
Posts: n/a
Default 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