Excel Worksheet Tips: Average Without Zeros

Have you got a collection of data that you wish to take the average of, but do not want to include zeros? By including them, it will alter the average you are looking for.

Excel 2003


Excel 2007 & 2010


This is the quick way to use the correct formula.

Come check out the directory for the rest of my excel tips!



Posted by:submeg

Musician, Writer and Inspirer. I discuss the projects I am working on, the services I provide and my general thoughts.

Tell me what you think!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s