Thread
:
function for average without zero
View Single Post
#
1
[email protected]
Posts: n/a
=average(if((A1:A10<0,A1:A10,"")
array entered (ctl, shift, enter)
should do what you need
hth RES
Reply With Quote