AVERAGE will ignore blanks as long as at least one cell has a numeric
value, so check your Jan08!F44 and Feb08!F44 cells...

Are you sure you don't have a #DIV/0 in one of the others?

If your sheets are in date order, you might try:

=IF(COUNT(Jan08:Dec08!F44)=0,"No data",AVERAGE(Jan08:Dec08!F44))



In article ,
tryn2learn wrote:

I am trying to get a total for a year to date.
in doing my year to date sheet i of course don't have data yet for
march-december
and because of that my total colum shows as #div/0!

the formula i am using reads as:
=AVERAGE(JAN08!F44,FEB08!F44,MAR08!F44,APR08!F44,M AY08!F44,JUN08!F44,JUL08!F44
,AUG08!F44,SEP08!F44,OCT08!F44,NOV08!F44,DEC08!F44 )

thank you in advance,