adding 4 smallest numbers greater than zero
Thanks Luke M... I really appreciate your help!
"Luke M" wrote:
Might be able to shorten this somehow, but this array** formula works:
=SUM(SMALL(IF(A2:A100,A2:A10),1),SMALL(IF(A2:A10 0,A2:A10),2),SMALL(IF(A2:A100,A2:A10),3),SMALL(IF (A2:A100,A2:A10),4))
**Array formulas must be confirmed using Ctrl+Shift+Enter, not just Enter.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Tangyteacher" wrote:
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!
|