I have a column with different sets of values. On another worksheet I want
to to make a formula using COUNTIF that states how many times a value from
another column in the first sheet appears when a given value is set.

Example.

In the first sheet in column 1 the number 554 appears 10 times. In another
column the values corresponding are in a range of 1-4. On another sheet, I
want to do a COUNTIF where the range selected is 554 on the first sheet.