I have a small spreadsheet on which I keep weekly scores and I would like to total the 6 highest from a range of cells while ignoring certain cells within the range.
Cell range
D3>AG3 (inclusive)
Excuded cells
G3,K3,P3,T3,X3,AC3.
I realise that this will probably be a very small formula but I am a beginner at this, also a Golden Oldie.
Thanks in advance for any help.
ptkdave
=(sum(d3:ag3)-sum(g3,k3,p3,t3,x3,ac3)) SHould work, havent tested.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Thanks but I only want the highest 6 from the D3>AG3 Range, to let you know these are golf stapleford points and I wish to total top6 scores.Originally Posted by nathansav
Thanks anyway
ptkdave
Try this formula:
Formula:
Please Login or Register to view this content.
As you can see, exclusion of some cells is obtained by ommitting them in first argument of LARGE. To force LARGE function to treat all subranges as first argument, they are surrounded by additional parentheses.
as 1...6 array is given explicite, there is no need to committ this formula as array one (while it IS array formula in general sense).
Best Regards,
Kaper
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks