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...
But all I get is a #NAME? response.
Does AVERAGEIF work in Excel 2003? If not, is there a workaround?