Find a place where you want to count the average. Use your cursor to select the function and press the Tab Select the values you want to calculate the average C2C11 and press Enter. As with the AVERAGE function you can enter it one of three ways.
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.
It is calculated by adding a group of numbers and dividing the result by the count of those numbers. Summary To average by month you can use a formula based on the AVERAGEIFS function with help from the EOMONTH function. Click the insert function button fx under formula toolbar a dialog box will appear Type the keyword AVERAGE in the search for a function box an AVERAGE function will appear in select a function box. The AVERAGE function used on cells B4B19 in this example returns the same result as the TRIMMEAN function with a trim percentage of 25.