Attached is a sample workbook that I'm trying to work with fromulas.
This is actually the same probelm I have in:
http://www.excelforum.com/excel-work...nd-sumifs.html
but this time, it's more complicated because of the details.
with Column C, what I want to return is:
If Column B >= 1, sum data on Data tab column B with the same code(vlookup(File!A7, Data!A2:A159,1,false)), until it reaches the value of column B.
I tried formulating but I can't get the correct formula, please see my formula in I7.
With columns E and G, I can't even think of a clearer description, but please see my notes on the side.
been working on this since May and I hope I can do this perfectly this time.
Thanks from all the help I get in this forum!
And thank you in advance for helping me with this project!
Bookmarks