AVERAGE

No Comments

“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








You can check it yourself by copy the highlighted table and pasting in the first cell of the spread sheet.

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.