“AVERAGE”
Used for – “AVERAGE” Function in MS Excel is used tell MS excel
that a excel has to calculate the average of cell value (if numbers/fraction) /
numbers / fraction or range of cells and display the end result achieved.
Syntax – AVERAGE(Number1, [Number2],…….,[Number255])
or
AVERAGE(Number Range1, [Number Range2],…….,[Number Range255])
Example – Suppose you have to find the
average of cell B3 & B7, B3 to B7 and
B3 to B7 & C3 to I3 and result should be displayed in cell A1, C1 and E1
respectively, then you can write the formula as shown in the example below:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
=AVERAGE(B3,B7)
|
=AVERAGE(B3:B7)
|
=AVERAGE(B3:B7,C3:I3)
|
||||||
2
|
|||||||||
3
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
|
4
|
2
|
||||||||
5
|
3
|
||||||||
6
|
4
|
||||||||
7
|
5
|
||||||||
And
result you get as under:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
3
|
3
|
4.1666667
|
||||||
2
|
|||||||||
3
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
|
4
|
2
|
||||||||
5
|
3
|
||||||||
6
|
4
|
||||||||
7
|
5
|
Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.