Count ifs

  • Thread starter Thread starter Chad Wodskow
  • Start date Start date
C

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
 
Try the below

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

If this post helps click Yes
 
=SUMPRODUCT(--(B2:B5="Current")+(B2:B5="Target"))
=COUNTIF(B2:B10,"Current")+COUNTIF(B2:B10,"Target")

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

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

Adjust the range as you need.

Squeaky
 
Back
Top