I have data that increases on a daily basis and is input on the shop
floor from a drop-down list. Some of the data that is collected
includes day, the type of failure and the corresponding part that
failed.

For example:
COL_A COL_J COL_H
Date Type of Failure Part # Failed
10/20/2005 Supplier – Porosity 1357 – Gasket
10/20/2005 Internal – Cracked 5678 – O-Ring
10/20/2005 Internal – Split 2345 – Seal
10/20/2005 Internal – Pinched 1234 – Seal
10/20/2005 Internal – Pinched 1234 – Seal
10/20/2005 Internal – Pinched 1234 – Seal
10/20/2005 Internal – Pinched 1234 – Seal
10/21/2005 Internal – Pinched 1234 - Seal
10/21/2005 Internal – Cracked 5678 – O-Ring
10/21/2005 Internal – Cracked 5678 – O-Ring
10/21/2005 Internal – Cracked 5678 – O-Ring
10/21/2005 Internal – Cracked 5678 – O-Ring

I somehow need to develop a formula that will count the types of
failures and the corresponding part number that failed by the day it
occurred. I can do a COUNTIF but it cannot do all that is asked. I also
tried to filter by date then use COUNTIF, but it still looks at all data
in the column.

Can someone point me in the right direction?


--
Racorfrank
------------------------------------------------------------------------
Racorfrank's Profile: http://www.excelforum.com/member.php...o&userid=17882
View this thread: http://www.excelforum.com/showthread...hreadid=479556