Top 4 scores in excel

M

maff

Hi
I need a formula which will total the top 4 scores out of 6. The scores
would be in cells B4,D4,F4,H4,J4,L4 The cells in between these would have
data that is not relevant to the scores. I've tried LARGE from a formula I
googled but that didn't work, I probably did it wrong.
Thanks for any help offered
 
J

Jim Cone

Select the SIX cells and name them something appropriate..."BigFour" ?
Then brute force will work...

=SUM(BigFour) -LARGE(BigFour,5) -LARGE(BigFour,6)
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Permutations add-in highlights valid words)



"maff" <fiffers97@o2.co.uk>
wrote in message
news:NR2%o.824$zw7.293@newsfe12.iad...
 

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

Top