Unfortunately the data is not in a range so I can't use any A2:A7 functions.
"Andy Brown" wrote:
"Mike" wrote in message
...
Averaging noncontiguous numbers ignoring zeros?
=AVERAGE(IF(A2:A7<0, A2:A7,"")) . I've not been able to revise this
formula to calculate noncontiguous data. Any ideas?
=SUM(A2:A7)/COUNTIF(A2:A7,"0")
, possibly.
HTH,
Andy
|