So I am working on an Excel project. I am have a list of style numbers, total of around 1400. I am trying to find an equation that will go through another worksheet, 32,000 lines long, and find how many times the style number comes up. This is the first equation im trying to figure out.

The second is referecing a column in the same row as teh style number and giving me a sum that will add up allof the the values in that column associated with teh style number.

Thank you.