More Excel tips and online courses [ Ссылка ]
Calculate average excluding zero in Excel. If there are zeros in a range, the AVERAGE function will include them in its calculation.
To exclude the zeros you need a conditional average formula. By using the AVERAGEIF function in Excel we can create an average excluding zero.
Here are the timings of the video.
00:00 - AVERAGE function on a range including zeroes
01:38 - AVERAGEIF function to average excluding zeroes
03:23 - Closing words
Find more great free tutorials at;
[ Ссылка ]
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]
Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]
