I work for a bicycle manufacturer and I keep track of our inventory with this excel sheet. Colum a is the colors and colum b is the customer. Sometimes colum a is a backorder or I could just count colors. I tried both of the suggestions and they are not exactly what I am looking for. I will try and explain better. Say in column a I have 10 "blue" in column b 4 of the rows also show "stock" I need the formula to give a total number of rows which say blue and stock in them. Thank you for being so kind and helping me with my excel infantcy!