Forum Discussion
Average of a range
Is it possible to enter a formula to calculate the average (excluding zero/blanks) and make sure there are a certain number of values used. i.e. a sheet contains 104 cells with values, some of th...
=AVERAGE(SMALL(IF((A1:A104<>"")*(A1:A104<>0),A1:A104),ROW(1:52)))With e.g. Excel 2013 you can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.