AVERAGEIF conversion into 2003?

[Ksandra2901]

Hi Guys,


Have got the following formula which works a treat in 2007 but won't translate into 2003.


=IF(ISERROR(AVERAGEIF(D54:O54,"<>#N/A")),"",AVERAGEIF(D54:O54,"<>#N/A"))


#N/A's are in place so I can chart a years worth of data.


What can I use instead?


K

 

[keymaster]

@K...


Replace the AVERAGEIF(D54:O54,"<>#N/A") with below


SUMIF(D54:O54,"<>#N/A")/COUNTIF(D54:O54,"<>#N/A")


It should work.

 

[Ksandra2901]

Oooooo, the master himself! I am honoured! lol


Thanks for quick response.


So it now looks like this, but it doesn't seem to be doing the sum correctly?


=IF(ISERROR(SUMIF(D54:O54,"<>#N/A")/COUNTIF(D54:O54,"<>#N/A")),"",SUMIF(D54:O54,"<>#N/A")/COUNTIF(D54:O54,"<>#N/A"))


Have I missed something?

 

[Ksandra2901]

Never mind, my bad. I've fixed it, it works perfectly now, thank you!!


K