Why not fix the N/As? Use something like:

=if(isna(yourformula),"",yourformula)

It will make your spreadsheet cleaner, and Average will ignore the blanks.

Regards,
Fred

"Kevin Anderson" wrote in message
...
I wrote a spreadsheet in Excel 2007 that uses the =AVERAGEIF function, when
I
loaded it on to my work computer that has Excel 2002, it does not work. It
there a way to work around this. The formula that I wrote is
=AVERAGEIF(C9:I9,"1"). It is a sales averaging formula, since the formula
refers to seven days and very few people work seven days there will be
some
error references (#N/A) in the fields that I want to average. Any help
would
be appreciated.