【Introduction to Excel Function Series】002: The AVERAGE Function
Thread Content
The second installment also starts with relatively simple functions. The topic for this time is the AVERAGE function. Average means “mean, average value” in English. In Excel tables, the AVERAGE function is used to calculate averages. Syntax and description: AVERAGE(Number1, Number2……). Here, Number1, Number2, ... are 1 to 30 parameters for which the average value is to be calculated. 1. Parameters can be numbers, or names, arrays, or references that involve numbers ； 2. If there are text logical values or empty cells in the array or cell reference parameters, their values will be ignored. However, if the cell contains a zero value, it is included in the calculation ； 3. When calculating the average of values in cells, it is important to keep in mind the difference between empty cells and cells containing zero values. Especially when the checkbox for \"Zero values\" is unchecked on the \"View\" tab of the \"Options\" dialog box, empty cells are not included in the calculation, but zero values are. To view the Options dialog box, click the Options command in the Tools menu. For example, if A1:A5 are named Scores with values of 10, 7, 9, 27, and 2 respectively, then: AVERAGE(A1:A5) equals 11; AVERAGE(Scores) also equals 11. AVERAGE(A1:A5, 5) equals 10. Additionally, AVERAGE(A1:A5) is equal to SUM(A1:A5)/COUNT(A1:A5), which is also 11. If C1:C3 are named OtherScores with values of 4, 18, and 7 respectively, then AVERAGE(Scores, OtherScores) equals 10.5.
Friendly tip: There are actually many animated images that demonstrate related functions, and combining text with animations is simply perfect~
Good suggestion; I can give it a try next time. Besides, this is something that can’t be relied on consistently; it’s best if one knows how to do it oneself.
It’s very simple – just look at my post; the GIF was created by me. The software is mentioned in the reply, and you can download it to try it out yourself~ http://bbs.hcbbs.com/thread-1480452-1-1.html
The original poster’s post is being updated. . During the update, you can take a look at this post summarizing useful tips for using the computer-resource version of Excel sheets