average if

  • Thread starter Thread starter tim
  • Start date Start date
T

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
|
 
Hello Tim,

Change ; to , and try again.

See answer to "Average IF problem"-post.

Please do not break threads by changing the subject text.
After an initial post, use reply instead of posting a new message.
Broken threads can be very confusing to those that already replied to you.

Have a marvelous day.
 
Try replacing the semicolon with a comma

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

still array entered
 
Back
Top