MS Excel 2002 Array Formula =large
This is my first time here, so any help would be greatly appreciated.
I am having difficulty finding the correct formula for the Sum of 12 cells but only taking the 8 highest.
What i am doing is taking the sum of 12 months of scores but only the 8 highest for the year.
So thanks in advance if anyone can help me.
Last edited by fortbibby; 01-11-2011 at 12:10 PM. Reason: Mod request
This formula is an array formula:
=SUM(IF(A1:A12=LARGE(A1:A12,{1,2,3,4,5,6,7,8}),A1:A12))
...confirm it by pressing CTRL-SHIFT-ENTER.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I will give it a try, Thanks for the quick post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks