Count ifs

[Chad Wodskow]

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

 

[Jacob Skaria]

Try the below

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

If this post helps click Yes

 

[ryguy7272]

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

HTH,
Ryan--

 

[Squeaky]

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

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

Adjust the range as you need.

Squeaky