• 100% Satisfaction Guarantee
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1947
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now

# Hello, I have a question about adding a formula in Microsoft

Hello,

I have a question about adding a formula in Microsoft Excel. What I am trying to do is this, I have a column with 6 rows. In each row there will be a random number box. I would like the spreadsheet to calculate only four out of the lowest 6 numbers. So the two highest numbers that formula should eliminate those numbers and not factor into the calculation. For example if these were the 6 numbers; -1, -2, 0, 5, -5, 3 the formula should calculate -8 as the answer.

Thanks

The-PC-Guy :

The-PC-Guy :

give me a few minutes and Ill create an example sheet of how this can be done

Customer:

ok. I am trying to make a Golf Sheet for my Masters Pool.

The-PC-Guy :

ok

The-PC-Guy :

i can just give you a formula if you prefer

The-PC-Guy :

what 6 cells do you have the 6 numbers in

The-PC-Guy :

for example A1 - A6

Customer:

ok. that would be fine

The-PC-Guy :

so I assume you want the sum of the lowest 4 numbers whether positive or negative

The-PC-Guy :

or zero even

Customer:

yes correct

The-PC-Guy :

which collum and rows are the 6 numbers in

Customer:

ok one sec

Customer:

column B11 - B16

The-PC-Guy :

ok

The-PC-Guy :

give me a minute to create the formula

The-PC-Guy :

=SUM(SMALL(B11:B16,1),SMALL(B11:B16,2),SMALL(B11:B16,3),SMALL(B11:B16,4))

The-PC-Guy :

let me know how this works

The-PC-Guy :

Customer:

ok

Customer:

Yes that works. Thank you. It only works when each box has a number in it. If a box is empty the formula does not work.

The-PC-Guy :

yes, thats correct

The-PC-Guy :

sum doesn't work on blanks or letters