calculate based on color

R

redneck joe

Every time ya'll have helped I was working on something for the
corporate office, now I've been transferred to the corporate office -
not sure if that's good or bad...



Routing and scheduling workbook with multiple tabs. We have three
colors of rows to signify the status (open, closed, issue)


I want to calculate the number of blue rows (issue) to the front
(summary) tab. Is that possible, like a COUNTIF formula?? I could
just add another regular formula and have numerical codes for the same
thing, but there is aready enough business going on in there.


If not possible, any ideas? The open/losed calculation is no big deal,
but there are about 30 different subsets under "issue" and don't really
want to do another giant validation...
 
M

MDubbelboer

in a similar vein is there a list somewhere of which numbers map t
which colours as far as excel is concerned.

i.e. if 3 = red background what is 1,2,4,etc...without me having to pu
them all in obviously.

thanks in advanc
 
R

redneck joe

Cool - one more question:
Another COUNTIF ~ i have a column that contains date and time frame
(07/06/2006 AM) and I want to COUNTIF the AM or PM part of that cell.


Possible or only if I break that out?
 
Top