The AVERAGE function averages all of the numeric cells in a range.
To use the AVERAGE function:
Enter the formula =AVERAGE(range) where range is any range. This produces the average of the numeric values in the range.
Note that the AVERAGE function ignores labels and blank cells in the average. So, for example, if the range C3:C50 includes scores for students on a test, but cells C6 and C32 are blank because these students haven’t yet taken the test, then =AVERAGE(C3:C50) averages only the scores for the students who took the test. (It does not automatically average in zeros for the two who didn’t take the test.)
Try it! Use the AVERAGE function to calculate the averages in cells B1 and B2. (For B2, you’ll have to replicate the exam scores in column C and make some changes.)
Dostları ilə paylaş: |
