Referencing other worksheets?

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.

The style numbers are listed in a column on a seperate worksheet. On the worksheet im trying to reference its in columm d.

And for the dollar values associated with the style numbers, are located in column E.

I hope this helps make my question easier to answer.

Thank you so much. the first equation helped. But im confused on the second. So basically i need that equation to reference the same rows that the style numbers occur on, but a seperate column.

My first equation was =COUNTIF(Sheet name!F;F,'Sheet2'B2)

the numerical value column i want to sum is column m on Sheet 1

I would, but its on my work computer and im on my lap top right now.

It goes:

Sheet 1
Column F= Style Number and Column N=Value of that specific row

Sheet 2 has
Columb B= Style Number, ColumnD=the COUNTIF equation and I want columnE=the sum of all values located in column N on the rows that the style numbers appear in Sheet 1 Column F that equal the value of Column B row 1 for example.

But thank you so much for your help. It helped me make significant progress on this SS. Both the equations worked as well.

Cheers and a Star to you.