Formula

  • Thread starter Thread starter Chuck Pringle
  • Start date Start date
C

Chuck Pringle

I need help with a formula that will provide the sum of
the lowest for values in a specific range. Where there
are multiple values that are the same, I need only the
sum of four of them.

Any Help????
 
=SUM(SMALL(TheRange,ROW(1:4)))

entered as an array formula with <Ctrl> <Shift> <Enter>.
 
in this case no need for an array formula :-)
Click to expand...
...

Did you try

=SUM(SMALL(TheRange,{1;2;3;4}))

and assume it would work exactly the same as

=SUM(SMALL(TheRange,ROW(1:4)))

?

Or did you implicitly change SUM to SUMPRODUCT? Vasant's formula, as written,
*DOES* need to be array-entered, or it'll just return MIN(TheRange). If SUM were
changed to SUMPRODUCT, then it wouldn't need to be array-entered.
...
 
Hi Harlan:

Actually I did test mine before posting and confirmed that it didn't work as
a regular formula. But I thought Frank's solution was better in this case
(only 4 elements) since it didn't need to be array-entered.

I didn't think about SUMPRODUCT.

Regards,

Vasant.
 
Harlan said:
...
..

Did you try

=SUM(SMALL(TheRange,{1;2;3;4}))

and assume it would work exactly the same as

=SUM(SMALL(TheRange,ROW(1:4)))
Click to expand...

Hi Harlan
yes this was my assumption (should have stated this though). Hope you
won't prove me wrong on this :-)

Or did you implicitly change SUM to SUMPRODUCT? Vasant's formula, as
written, *DOES* need to be array-entered, or it'll just return
MIN(TheRange). If SUM were changed to SUMPRODUCT, then it wouldn't
need to be array-entered.
Click to expand...

Ack
 
Back
Top