Count ifs
 

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

Count ifs
 

Try the below

=SUMPRODUCT(--ISNUMBER(MATCH(A1:A10,{"Current","Target"},0))*(B1 :D10="Product1"))

If this post helps click Yes
---------------
Jacob Skaria


"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

Count ifs
 

=SUMPRODUCT(--(B2:B5="Current")+(B2:B5="Target"))
=COUNTIF(B2:B10,"Current")+COUNTIF(B2:B10,"Target" )

HTH,
Ryan--


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"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

Count ifs
 

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