Excel has many ways for you to find the middle point to your data. The three most common are average (what I would call mean), median, and mode.
Now I will try not to go all maths teacher on you here, but a quick refresh on each of these.
Average is what you get when you add up all the numbers and divide by how many number there are. Technically, this is called mean, but Excel calls it average.
Median, is the middle number, when you have put them all in order.
Mode, is the most common number.
=AVERAGE(number1, [number2], …)
The input for average is a list of numbers, either from individual cells, or a range.
=MEDIAN(number1, [number2], …)
Again, the input is standard, list of numbers, or a range with numbers in the cells.
One thing to note with median, is if there is an even number of numbers, so there is no exact middle one, then the average of the two middle numbers is used to return the median. As seen below.
=MODE(number1,[number2],…)
Again, mode takes in a list or range. This is actually an old formula and is only included in Excel to maintain compatibility with Excel 2007 and earlier. The new version is either MODE.MULT or MODE.SNGL. These take in a list or range as well, however what they return is quite different. MODE.SNGL is the direct replacement for mode. It will find the most common number in your list. If there are two numbers that both appear that many times it will only return one of them, whichever it counted first.
MODE.MULT will return all the numbers that are the most common, in a spilled array. Notice the blue border in the image below, showing the result of the formula spilling down three cells.
There are other options as well; AVDEV, AVERAGEA, AVERAGEIF, GEOMEAN, and HARMEAN; but if you haven’t done a stats course, probably not much need to delve into those, although AVERAGEIF can be very handy if your data has groups that you are wanting to analyse.