Bill Golden

asked on

# PROBLEMS WITH AVERAGEIF FUNCTION IN EXCEL 2003

Earlier I posted a problem of having 10 cells with numeric values and needed an average given that not all cells may have values.

If received a solution that goes like this...

="The average of the "& COUNTIF(A1:A10,"> 0") & " years is $ " & AVERAGEIF(A1:A10,">0")

I was unable to get it to work and a reply brought no response.

In testing, I brought the formula down to its simplest use...

=AVERAGEIF(A1:A10,">0")

But all I get is a #NAME? response.

Does AVERAGEIF work in Excel 2003? If not, is there a workaround?

If received a solution that goes like this...

="The average of the "& COUNTIF(A1:A10,"> 0") & " years is $ " & AVERAGEIF(A1:A10,">0")

I was unable to get it to work and a reply brought no response.

In testing, I brought the formula down to its simplest use...

=AVERAGEIF(A1:A10,">0")

But all I get is a #NAME? response.

Does AVERAGEIF work in Excel 2003? If not, is there a workaround?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thank you. I had come to a total halt. Please read next question I will be posting shortly.

if you don't want an array formula, pls try

Open in new window

Regards