This should be easy, but my brain's not working to par.
I'm having trouble using the MAX of one column of numbers to find another number in the same row. I know I should know this, but I can't make it work...
Additionally, I then want to sum all numbers LESS than that, and another sum of all numbers GREATER than that. But I can;t play around with it to figure it out until I get the lookup fixed.
Please help a poor dummy...
Sample sheet attached.
Last edited by Gunther Maplethorpe; 06-22-2011 at 03:40 PM.
Hello, try;
F17,
=INDEX(A2:A10,MATCH(F16,B2:B10,0))
F18,
=SUMIF(A2:A10,"<"&F17,B2:B10)
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Hi
Almost there
F17
=INDEX(A2:A10,MATCH(F16,B2:B10,0))
F18
=SUMIF(A2:A10,"<"&F17,B2:B10)
--
Regards
Roger Govier
Microsoft Excel MVP
Lookup needs sorted numbers use
=INDEX(A2:A10,MATCH(E16,B2:B10,0))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Looks like all three of you had the same answer, and posted almost simultaneously. Thanks bunches to all of you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks