adding 4 smallest numbers greater than zero
Try this array formula**.
Assuming there are at least 4 numbers 0.
=SUM(SMALL(IF(A1:G10,A1:G1),{1,2,3,4}))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
--
Biff
Microsoft Excel MVP
"Tangyteacher" wrote in message
...
I am a high school golf coach making a spreadsheet for my golfers stats
using
excell 2007. I need to be able to add the 4 lowest values in a data table
that are greater than 0
Ex.
75,76,77,78,79,0,0 are the values. I need a formula that will automaticly
ignore the zero's and add the 4 smallest values. In this case it would be
75,76,77,78.
Any help would be appreciated!
Thanks!
|