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

=SUM(A1:A10)/COUNTIF(A1:A10,”<>0″)

Excel 2007 & 2010

=AVERAGEIF(A1:A10,”<>0″,A1:A10)

This is the quick way to use the correct formula.

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

Submeg

IT

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 )

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s