I have 2 worksheets.

I need to compare a single figure in column A on sheet 1 to the entire
column B on sheet 2 and count how many times the figure in A appears in
column B and then place this in Column C on sheet 1.

CAn somebody please help me with the formula???????????