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

I am just learning excel. teachng mysef.I do the scores for

I am just learning excel. teachng mysef.I do the scores for our league. I have the weeks scores in a colum say 7 shooters and I want to write a formula to pick out the highest 4 scores and add them together and put them in a cell at the bottom of the colum. Can I do this and how do I write the formula. Help
Thank you
Kevin Wise

The-PC-Guy :

The-PC-Guy :

I have the formula you are looking for

The-PC-Guy :

just give me a second to type it out

Customer:

ok thanks

The-PC-Guy :

Customer:

It is multiple colums I have each week in differant colums but say for now cells b3:b31

The-PC-Guy :

ok

The-PC-Guy :

the formula will be able to be copied to other columns

Customer:

do i need to change the colum letter or will it take care of that when i copy it /b to c colum

The-PC-Guy :

no

The-PC-Guy :

it is relative

The-PC-Guy :

here

The-PC-Guy :

put this in say b32

The-PC-Guy :

=SUM(LARGE(B3:B31,{4,3,2,1}))

The-PC-Guy :

then you just copy over to c column

The-PC-Guy :

D column

The-PC-Guy :

however many you need

The-PC-Guy :

PLEASE REMEMBER TO RATE MY SERVICE SO I AM PAID FOR MY TIME

The-PC-Guy :

YOU DO SO WITH THE SMILEYS BENEATH THIS CHAT

Customer:

thank you very much

The-PC-Guy :

The-PC-Guy :

PLEASE REMEMBER TO RATE MY SERVICE SO I AM PAID FOR MY TIME

9:22 AM

YOU DO SO WITH THE SMILEYS BENEATH THIS CHAT