Count ProdKey
 

I have two tabs, Info by Style and Info by SKU. They have a ProdKey field in
common. Info by Style will have it once, Info by SKU multiple times. On the
Info by Style sheet I want a count of the number of occurances of each
ProdKey on the Info by SKU sheet.

Any help will be greatly appreciated!
B

Count ProdKey
 

DUH!

countif

I knew it would be easy!

"berniean" wrote:

I have two tabs, Info by Style and Info by SKU. They have a ProdKey field in
common. Info by Style will have it once, Info by SKU multiple times. On the
Info by Style sheet I want a count of the number of occurances of each
ProdKey on the Info by SKU sheet.

Any help will be greatly appreciated!
B