On Apr 5, 12:03*pm, GS wrote:
Annabelle presented the following explanation :

I have a long spreadsheet (columns A - HB). In column A5, I want to
average all of the entries on this row where the SCORE column is
higher than 0.00.

Example:
Ave-to-Date = A5

SCORE = F5, J5, N5, R5, ...HB5

The SCORE cells contain a formula [=SUM(C5-D5-E5)/((40*1-E5)*0.9)], so
they all read as "0.00" until that week's entry has been made. I only
want to average the cells that contain data, thus the 0.00 note.

Any help would be greatly appreciated.
Annabelle

In XL2007 you can use the AVERAGEIFS() function as follows:

* In cell A5:
* =AVERAGEIFS(F5:HB5,F1:HB1,"SCORE",F5:HB5,"0")

* **Assumes each 'SCORE' column is labeled "SCORE" in Row1.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Thank you, Garry. However, I'm still on 2003 (Fortune 50 company I
work for is a bit slow on office technology). Is there another
function that might work for my older Excel version?