Average formula

F

ferg

Hi people
need a formula that will give the average of the highest 4 numbers in
row of 10 to 12 cells. Hope that explains my prob.
First post here and hope to learn plenty
Thanx
:
 
M

Muhammed Rafeek M

Hi
Hope below mentioned function will solve your problem.

=AVERAGE(LARGE(A1:A15,1),LARGE(A1:A15,2),LARGE(A1:A15,3),LARGE(A1:A15,4))

With Regards
Rafeek
 
L

Leo Heuser

ferg said:
Hi people
need a formula that will give the average of the highest 4 numbers in a
row of 10 to 12 cells. Hope that explains my prob.
First post here and hope to learn plenty
Thanx
:)
Click to expand...

Hi Ferg

One way:

=AVERAGE(LARGE(C3:L3,{1,2,3,4}))
 
B

b&s

Muhammed said:
Hi
Hope below mentioned function will solve your problem.

=AVERAGE(LARGE(A1:A15,1),LARGE(A1:A15,2),LARGE(A1:A15,3),LARGE(A1:A15,4))

With Regards
Rafeek
Click to expand...

.... Just an alternative:

=AVERAGE(LARGE(A1:A15,{1;2;3;4}))
 
F

ferg

Thanx Rafeek & Leo both formulas work
Now can i put IF in formula so i dont get #num with less than 4 nums
In other words i dont want a calculation ( blank cell) unless there i
4 nums plus
Thanx;
 
R

RagDyeR

One way:

=IF(COUNT(A1:A10)>=4,AVERAGE(LARGE(A1:A10,{1,2,3,4})),"")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Thanx Rafeek & Leo both formulas work
Now can i put IF in formula so i dont get #num with less than 4 nums
In other words i dont want a calculation ( blank cell) unless there is
4 nums plus
Thanx;)
 
L

Leo Heuser

ferg said:
Thanx Rafeek & Leo both formulas work
Now can i put IF in formula so i dont get #num with less than 4 nums
In other words i dont want a calculation ( blank cell) unless there is
4 nums plus
Thanx;)
Click to expand...
You're welcome, Ferg :)

Regards
Leo Heuser
 
Top