Hi all,

I am trying to calcuate the average for cell C17 in 12 different sheets
within the same spreadsheet. This is what I am using. But its not working if
there is an empty cell and its not averaging correctly. Any ideas?

=IF(ISERROR(AVERAGE(Jan06!C17)+(Feb06!C17)+(Mar06! C17)+(Apr06!C17)+(May06!C17)+(Jun06!C17)+(July06!C 17)+(Aug06!C17)+(Sept06!C17)+(Oct06!C17)+(Nov06!C1 7)+(Dec06!C17)),"",(Jan06!C17)+(Feb06!C17)+(Mar06! C17)+(Apr06!C17)+(May06!C17)+(Jun06!C17)+(July06!C 17)+(Aug06!C17)+(Sept06!C17)+(Oct06!C17)+(Nov06!C1 7)+(Dec06!C17))

Thanks for any help!!!
--
Bruce DiPaola