This one is a bit tricky.
I've attached a sheet with the preferred outcome in Column AA with some examples.
In essence I require a formula in Cell AA that will look left From C to X, not include the 2 highest figures but give me the sum total of what is left.
Obvioulsy if I can have a one horizontal look/criteria it would be brilliant. Sample data is on 28 clients, actual is in the thousands.
Not sure if it is possible, but I have to ask.
thanks, if anyone can help me....
Last edited by Christopherdj; 08-19-2013 at 12:36 AM.
Im confused. If you want the count to exclude the 2 highest, why not just use =count(range)-2?
Looking at your sample, it looks like you are trying to SUM() the data, not count?
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
Yes, I require the sum total minus the two highest cells.
OK try this, copied down...
=IF(COUNTIF(C2:X2,">0")=3,LARGE(C2:X2,3),SUMIF(C2:X2,"<"&LARGE(C2:X2,2)))
Works like a charm. Thank you so much.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks