Thread: Count ifs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chad Wodskow[_2_] Chad Wodskow[_2_] is offline
external usenet poster
 
Posts: 4
Default 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