Returning NULL when there are zeros present

Z

zetatstrat

I used the formula below, it works fine, but if there are zeros in the race
line it returns zero as the smallest number.

=SUM(SMALL(13:A4,{1,2})/2)

How can I write the formula so that if there is a zero it will return
null, and then do the computation.

Zetastrat
 
D

Domenic

=SUM(SMALL(IF(A1:A10<>0,A1:A10),{1,2})/2)

OR

=AVERAGE(SMALL(IF(A1:A10<>0,A1:A10),{1,2}))

...both confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
 
Top