I need help. I have compiled a work sheet that contains master id
numbers for gage parts for a company. Every once and a while a part
will get rusted or scratched and this must be recorded. So I created
this worksheet that has the part size in the A column (consists of 900
different parts) and the serial of each gage of a particular part size
in the corresponding row.
So this has created a huge sheet of data. My boss takes a look at
the key that I used so that people know what all the colors mean.
Green means lost, Red means scratched, Pink means out of tolerance. He
told me that he would like to know how many parts that have been lost.
Each of these gages costs about $60 so he would like to see how much
money has been thrown away because of irresponsible workers.
The thing is that I have know idea how to enter a formula in and
I am not aware of any site that can explain this to me easily enough
for me to understand. Any help would greatly be appreciated.

-jojones88