Sometimes when doing data analysis in Excel we may need to find an average of numbers that correspond to either empty or non-empty cells. We get the result below. This video tutorial will show you how to calculate an average in Excel thanks to which youll be able to work out an average value of a group of numbers of.
The formula in F3 copied down is.
Select a blank cell for example Cell C3 enter the formula of ROUND AVERAGE A1A71 into it and press the Enter key. The criteria define which cells to average. Errors with the AVERAGE function If your AVERAGE function returns an error its likely because one of its inputs is an error like VALUE. Finding a Weighted Average 1.