Averages using array.

[Guest]

Hi there,

I am using the following array formula to work out an average of a row of
cells that contain numerical data. i,e not an empty cell and the value isnt 0.

=AVERAGE((IF(E49:IV49<>"",E49:IV49)),AND(IF(E49:IV49<>"0",E49:IV49)))

It works fine for empty cells, but it does not seem to ignore cells that
contain "0" or "0:00" any ideas???

 

[Bob Phillips]

=AVERAGE((IF((E49:IV49<>"")*(E49:IV49<>0),E49:IV49)))

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Fantastic,

Thankyou very much.

=AVERAGE((IF((E49:IV49<>"")*(E49:IV49<>0),E49:IV49)))

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)