# Reviewing Formulas and Functions Part 2: AVERAGE in Excel

Learning a selection of Excel formulas can take your reports to the next level. Mastering a few tips and tricks can not only save time for working professionals but using Excel formulas can help double-check the values listed on a spreadsheet. To simplify your work and make sure youâ€™re presenting accurate data, take a look at how to use the AVERAGE formula.

## AVERAGE in Excel

The AVERAGE function is used to determine the average value or number in a list of numbers. It effectively finds the midpoint of a number sequence.

Using the AVERAGE Formula

To determine the average of a list of numbers in an Excel spreadsheet, use the following formula:

• =AVERAGE(C4:C9)

You can also find the average of several number sequences by separating them with commas.

• =AVERAGE(C4:C9, B5:B7)

We at Learn Excel Now hope you feel comfortable creating using the SUM function in Excel. Next week, weâ€™ll wrap up the series with COUNT function in Excel so stay tuned!

Like Learn Excel Now? Follow us on social media and share our content with your networks!