In one cell put:
=COUNTIF(A1:D4,"Target")

In another cell put:
=COUNTIF(A1:D4,"Current")

Adjust the range as you need.

Squeaky

"Chad Wodskow" wrote:

I am working with a table of information and I want to count the number of
times a product shows up when it is classified as either current or Targetin
the table. I have tried sumifs but it isnt working for me.


Row Column A Column B Column C Column D
1. Current Product 1 Product 3 Product 6
2. Target Product 2 Product 3 Product 4
3. Current Product 1 Product 6 Product 7
4. Target Product 1 Product 2 Product 4

Thanks