Sorry bit of a newb

I have a relitively large spreadsheet at work that I am trying to basically update the way things are done. Throughout the day we update (color cordinate) this document. Essentually this is what each line consists of:
model:order#:line1:line2:line3:line4:line5:line6:l ine7:line8:line9:line10:total
We would check the order# and see the progress of the line# and color cordinate that respectively.
The question/problem I am having is creating a function/formula that will lookup all the lines with a specific model ID and give me the sum values from the line#s. Essentially the results would look something like
model:total:totalBLANK:total:GREEN:total:YELLOW:to talBLUE
I have created a few that essentially do this but more as a whole of the document and looking up specific items. I have created one that basically did this. The problem is the document changes often and I can't just assign a section of the document to be the lookup area as it can/will change.
Basically I need it to a half dozen or so sum values based on the condition of the lookup range that is dependent on the model ID of that row.

hope that makes sense and that someone has an idea of how I can do this.