Count values in a colum if cell in same row has specific value.

Hey guys,

I am working on a spreadsheet to assist in production for my company, since it is kinda hard to explain, I created an example of what I am working with.

What I want to do is create a separate table that counts whats going on in each month, in my example the week of 5/30, I want to know how many of 1001, 1002, 1003 and, 1004 are being produced that week alone, then be able to just copy the same formula and see the numbers for about 52 weeks out.

While in my example it may appear to be easier to hand count the batches per week, the real worksheet has thousands of batches and the chart snakes on for tens of pages.

My original idea was a countif statement with a search nested inside it but I was unable to achieve much success.

Originally Posted by NBVC

So if you have a unique list of SKUs and descriptions in Sheet2, A2:B2 down...

Then in C2 try:

=COUNTIFS(Sheet1!$A$2:$A$13,$A2,Sheet1!$C$2:$C$13,1)

adjust ranges to suit and copy down and across.. assuming dates are same as in sheet1.

Thanks for the help,


Im not quite understanding the formula, specificly criteria 1, and how that works. I did just have a Eureka moment where if I created a duplicate matrix for each SKU, and had a countif only if they equaled the sku I was looking up I could come out with the data I need in the format I need.