Getting averages from a column
Thanks I'll give it a go.
"T. Valko" wrote:
I think any average would be influenced by any zeros in the column
Does that mean you want to exclude 0?
This will exclude 0 and any errors. Array entered** :
=AVERAGE(IF(ISNUMBER(A1:A10),IF(A1:A10<0,A1:A10)) )
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
"tommy" wrote in message
...
Hi, I would like to work out the average from a column of numbers but
where
no data is available, it reads #N/A or #REF! So I can not use the
automatic
system found in auto sum, is there any way around this. Also I think any
average would be influenced by any zeros in the column, Can any one help.
Thanks in advance, Tommy.
|