The average calculated value in Excel
- In Excel, create a series of numbers. The Numbers do not have to be necessarily in a column or row, but can be located anywhere.
- Click on the field in which you want to calculate average.
- Enter the formula "=AVERAGE (***)". Instead of the asterisk, you must select the desired fields from which the average value is to be calculated.
- You can type in the fields. They select a range between two fields with the spelling of "field1:Feld5". Multiple fields, separate the fields with a semicolon.
- Alternatively, you can mark the desired fields with the left mouse pointer.
- Then, tap on the [Enter] key, Excel calculates automatically the average value of all selected Numbers.
Excel: average, calculate value
In a further practical tip can you find the 5 most annoying features in Excel and what to do about it.
