Formula to get sum of 4 low number ina range.

[Chuck Pringle]

I need help with a formula to get the sum of the lowest 4
numbers in a cell range. If all numbers are the same,
than I would only need the sum of 4 of the numbers.

All help is appreciated.

Chuck

 

[Frank Kabel]

Hi chuck
try
=SUM(SMALL(A1:A100,{1,2,3,4}))

 

[Chuck]

Thank You!!!

-----Original Message-----
Hi chuck
try
=SUM(SMALL(A1:A100,{1,2,3,4}))

--
Regards
Frank Kabel
Frankfurt, Germany



.