average if

[tim]

The array formula posted below didn't work

As a array formula entered
=AVERAGE(IF(A1:A5>0;A1:A5))
enter with CTRL+SHIFT+ENTER




| I need to average a column of data. Some of the cell
have
| zeros in them. I do not want to include the zeros in the
| calcultion. thus a column range (a1:a5) with 0,0,0,2,2
in
| the cells needs to retun 2 as the average.
| I thought the formula would look something like AVERAGEIF
| (a1:a5,>"0") but no luck
|
|
| using find and replace to eliminate 0's changes 105 to
15,
| so that didn't work,
| tools, option, view, deselect zeros doesn't do it either
|

 

[Ken Wright]

Try replacing the semicolon with a comma

=AVERAGE(IF(A1:A5>0,A1:A5))

still array entered

 

[tim]

it worked. thanks much
Tim