Average Multiple Worksheets without blanks or zeros

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.
 
M

Ms-Exl-Learner

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top