I have a gradebook that I am working on and would like to write a formula
that will drop the lowest score from a column. Does anyone have any
suggestions?
I have a gradebook that I am working on and would like to write a formula
that will drop the lowest score from a column. Does anyone have any
suggestions?
=sum(A:A)-MIN(A:A)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Stockeyd" <[email protected]> wrote in message
news:[email protected]...
> I have a gradebook that I am working on and would like to write a formula
> that will drop the lowest score from a column. Does anyone have any
> suggestions?
If you're looking to find the average grade amongst many, then Bob was
correct, but you'll want to add:
=(SUM(A#:A#)-MINA(A#:A#))/(COUNT(A#:A#)-1)
where # = the row numbers in the array. Otherwise you'll just have a total
sum of the points.
You can format the cells to limit the amount of remaining decimals places as
well if you like.
Aaron
"Bob Phillips" wrote:
> =sum(A:A)-MIN(A:A)
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "Stockeyd" <[email protected]> wrote in message
> news:[email protected]...
> > I have a gradebook that I am working on and would like to write a formula
> > that will drop the lowest score from a column. Does anyone have any
> > suggestions?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks