AVERAGE
Are A2:A4 always filled in with a number?
=SUM(A2:A4,A7)/(COUNTIF(A2:A4,"<"&0)+COUNT(A7))
sonicscooter wrote:
I understand the basics of array formulas,and the following formula
=AVERAGE(IF(A2:A4<0, A2:A4,"")) which doesn't count zero's,but i want the
cells A2:A4 but also with A7 added as a seperate cell for the formula to use
in its calculations =AVERAGE(A2:A4,A7) something like this
=AVERAGE(IF(A2:A4,A7<0, A2:A4,A7,"")) although this doesn't work,does
anyone know how to write this the right way..........Help please...
--
Dave Peterson
|