Formula to add 4 lowest numbers from a column of 6

M

Mike

I am a golf coach and am trying to figure out how to add the 4 lowest scores
to come up with the team score for my HS golf team.
I understand the simple sum formulas but do not know how to get it to pull
out the 4 lowest scores and total them from a column of 6 numbers.

Any help would be appreciated!

Thanks
 
D

David Biddulph

Suggestion number 1 is that instead of copying the formula from newsgroup to
the formula bar of the spreadsheet you tried to retype it and mis-spelled
something.
Suggestion number 2 would be that you have an error in a formula in one of
the cells leading into the formula, so that the #NAME? error occurs
somewhere in the B1:B6 range.
 
M

Mike H

Did you paste it exacly as posted. Small doesn't require the analysis toolpak
so make sure a rogue spaces hasn't got into SU M or SM ALL

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Average of last 5 entries 11
Cumulative formula for word table 0
Trying to subtract the two lowest values from a row of numbers 4
Need help with a function for a golf match spreadsheet 1
Sum (throw out highest and lowest) 1
How to add the 10 smallest numbers out of a range of 20 numbers. 3
pull out certain data 1
Averaging 4 out of 6 scores 1

Top