Link to home
Start Free TrialLog in
Avatar of zelfanet
zelfanet

asked on

Excel add row and not include lowest

On a Microsoft Excel spreadsheet, I want to add a row of columns up but not include the lowest number in the group.

How would I do this?
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Do you mean something like this?

=SUM(A5:G5)-SMALL(A5:G5,1)

Where you want to sum a5:g5, but exclude the smallest number
Avatar of zelfanet
zelfanet

ASKER

I did this:

=SUM(B30:L30)-SMALL(B30:L30,1)

It just added them up though, it didn't exclude the lowest one.
It should have summed them all up, then removed the smallest.
Are you sure there are no 0's in there?
What do you get for just
=SMALL(B30:L30,1)
If I just put this:

=SMALL(B21:L21,1)

I get 0

I am using Excel 2007.
So you
(1) have zeroes in the data
(2) need to exclude the lowest, non-zero value?
Yes......
=SUM(B30:L30)-SMALL(B30:L30,COUNTIF(B30:L30,0)+1)
cyberkiwi,

That worked, but what if they do have a zero at the end as their lowest one?

Also, how can I arrange it so that the name with the highest points moves to the top?
>what if they do have a zero at the end as their lowest one?
Then it takes 0 off... for a net effect of nothing, they are all 0's right?

>Also, how can I arrange it so that the name with the highest points moves to the top?
Do you mean the main data from B to L?
Select the range, including this column, and perform a sort on the column with this formula?
kiwi, Can you explain to me the sorting?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial