Calculating average of marks entered in cells E5, F5, G5, H5 and I5 using SUM
function. no spaming please it's important.
Answers
Answered by
0
Answer:
=SUM(E5:I5) / COUNT(E5:I5)
(or)
=SUM(E5:I5) / 5
- Average is also meant by arithmetic mean.
- The formula for arithmetic mean is Total Number / Count of the Number
- In this formula, we are adding all the numbers that have been entered in the cells E5, F5, G5, H5, and I5
- And dividing it by the count of the cells E5, F5, G5, H5, and I5
Similar questions