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!

--------------------
(Ms-Exl-Learner)
--------------------


"Shawn S." wrote:

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.

How are the worksheets named?


---
HTH

Bob Phillips

"Shawn S." wrote in message
...
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.