Excel Forum
Similar Content
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Easily Enter Fractions into Excel
Tutorial: This is a very simple trick to enter fractions quickly without having to manually format ...
Linking Cells in Excel
Tutorial: In this tutorial I am going to cover how to link cells together. This is a useful feature ...



Mr Excel & excelisfun Trick 13: AVERAGE without Zeroes


See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new Excel 2007 function. Also see Mr Excel use Fine and Replace to complete two amazing Average without Zeroes tricks.





Got a Question? Ask it Here in the Forum.