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?

How would I do this?

ASKER

I did this:

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

It just added them up though, it didn't exclude the lowest one.

=SUM(B30:L30)-SMALL(B30:L3

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)

Are you sure there are no 0's in there?

What do you get for just

=SMALL(B30:L30,1)

ASKER

If I just put this:

=SMALL(B21:L21,1)

I get 0

I am using Excel 2007.

=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?

(1) have zeroes in the data

(2) need to exclude the lowest, non-zero value?

ASKER

Yes......

=SUM(B30:L30)-SMALL(B30:L30,COUNTIF(B30:L30,0)+1)

ASKER

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?

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?

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?

ASKER

kiwi, Can you explain to me the sorting?

Thanks

Thanks

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

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

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