Hi walkingmac. Try Chip Pearson's site for information on summing or
counting based on colors: http://www.cpearson.com/excel/colors.htm. You
could also sort based on the model # and then use the subtotal function from
the data menu, if I'm understanding what you're trying to do. HTH
--
Sincerely, Michael Colvin


"walkingmac" wrote:


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.


--
walkingmac