How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1920
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

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

This answer was rated:

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 :

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

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 :

which column is your data in please?

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 :

your welcome

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



The-PC-Guy and other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions