A Super Complicated Formula Combinations that I don't even know how to start...

[geng]

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!