Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagAverageIF across multiple worksheets Im trying to Average the same cell across multiple worksheets, but ignore zeros. My formula is - =AVERAGEIF('Calculation Tab 1:Calculation Tab 53'!N38,">0") I Get the return of - #VALUE! is there a better formula?
