Hello Fellow Members,
I' am trying to figure out how to use the VLOOKUP, MAX, SUM Function together in a formula. Here is what I' am trying to do...
for some reason it wont let me post a image but here is a direct link to it:
http://i4.photobucket.com/albums/y14...hx99/excel.jpg
as you can see there are numbers in cells: C5:E13 AND G5:G13
What I want to do is find the highest number in the cells C5:E13 and SUM it with the number that is in the same ROW of G5:G13.
EXSAMPLE:
let's say the hightest number is in cell D7, I would want to ADD cell D7 with G7
here is a other one
let's say the hightest number is in cell E12, I would want to ADD cell E12 with G12
and one more
let's say the hightest number is in cell C9, I would want to ADD cell C9 with G9
and the formula will go in cell M5.
That's basically what i am trying to do, I hope I'm explaning myself right..
Thank You In Advance
_____________
Post moved from Excel programming - Richard Buttrey
Please also note the forum rule which asks you to attach actual workbook files rather than mere pictures. You can't expect those who want to help, to re-type your data.
Bookmarks