I need some help with eliminating a #DIV/0! error message. I am trying to consolidate and calculate an average from multiple spreadsheets within the same workbook using the following formula: =IF('Cass County'!G23=0,"",AVERAGE('Cass County:Marion County'!G23)). G23 is just making reference to one of the many cells I am calculating. I have approximately 12 spreadsheets (tabs). It calculates correctly if I have a value in the cell; however, if I have a 0 or blank it gives me the #DIV/0! error. Any help will be greatly appreciated.