How do I average positive numbers only while ingnoring any zero or negative values?
S Susannah Feb 14, 2005 #1 How do I average positive numbers only while ingnoring any zero or negative values?
S Susannah Feb 15, 2005 #3 Thank you! One further question...I see how this works with sequential cells; but if I want to average positive valued data from E7,E12,E22,E27 I can't seem to get it to work. Thank you in advance Peo!
Thank you! One further question...I see how this works with sequential cells; but if I want to average positive valued data from E7,E12,E22,E27 I can't seem to get it to work. Thank you in advance Peo!
