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

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.