Average Multiple Worksheets without blanks or zeros

  • Thread starter Thread starter Shawn S.
  • Start date Start date
S

Shawn S.

Have a workbook where each worksheet is a day of the month. The last
worksheet contains a running tally of each day;s information. I need to
average the same cells from different worksheets while omitting the blanks
and zeros, in case there is no data for an individual day.

Thanks.
 
Assume that you are having values in A1:A10 like the below

(A1:A10)
66
0
88
0
(Blank)
0
0
99
(Blank)
0

Use the formula like this, which will ignore blank cells and 0 (zero) values.
=SUM(A1:A10)/(COUNT(A1:A10)-COUNTIF(A1:A10,0))

Remember to Click Yes, if this post helps!
 
Back
Top