Use sum on the column and add a hidden column or function of =if(left=0,0,1) you can sum for the count to divide.
How do I average a range of data ignoring zero in Excel?
Follow
•
1
Add comment
More
Report
1 Expert Answer
Still looking for help? Get the right answer, fast.
Ask a question for free
Get a free answer to a quick problem.
Most questions answered within 4 hours.
OR
Find an Online Tutor Now
Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.
