Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to average and use sum min and count within one cell
I am trying to find the average of 4 grades, I have to eliminate the lowest
grade, but I have to use the Sum, Min and Count to get the answer |
#2
|
|||
|
|||
how to average and use sum min and count within one cell
It's just the average (sum/count), throwing out the lowest of the four:
=(sum(a1:a4)-min(a1:a4))/(count(a1:a4)-1) "gwtechie72" wrote: I am trying to find the average of 4 grades, I have to eliminate the lowest grade, but I have to use the Sum, Min and Count to get the answer |
#3
|
|||
|
|||
how to average and use sum min and count within one cell
One way:
=SUM(LARGE(A1:A4,{1,2,3}))/3 In article , "gwtechie72" wrote: I am trying to find the average of 4 grades, I have to eliminate the lowest grade, but I have to use the Sum, Min and Count to get the answer |
#4
|
|||
|
|||
how to average and use sum min and count within one cell
Or more simply
=AVERAGE(LARGE(A1:A4,{1,2,3})) Jerry JE McGimpsey wrote: One way: =SUM(LARGE(A1:A4,{1,2,3}))/3 In article , "gwtechie72" wrote: I am trying to find the average of 4 grades, I have to eliminate the lowest grade, but I have to use the Sum, Min and Count to get the answer |
#5
|
|||
|
|||
how to average and use sum min and count within one cell
Yeah, just a bit simpler...<g
Thanks for the correction! In article , "Jerry W. Lewis" wrote: Or more simply =AVERAGE(LARGE(A1:A4,{1,2,3})) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|