Formula in a range to add of letter codes

Hi Everyone...

I have a problem with a formula for a range of cells. I have few codes that I use to tell me what type of errors are made. However I need to know the total amount of times these codes are used in a perticular range of cells. How can I change this formula "=COUNTIF($K16:$K500,"OP")" To work with all my other codes to get the total amount used. My codes are OP,PT,PN,UP,NP,NP OR is there another way to add the times all these codes appears in a range of cells?

Thanks in advance.

Mike,

You can use:
=SUMPRODUCT(--(K1:K500="op") + (K1:K500="pt")) +++

Alon

outstanding works great...

Thanks for all the input...

Much Appreciated...

Mike

Please Login or Register  to view this content.