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