I have two columns with information which I need to collate.

The first column has variables such as apples, grapes, pears
The second column rates the first column from 1 to 5.

I want to count how many "1" ratings I get for apples and how many "2"
ratings and so on for each of the items in the first column.

I think I should be using the €œcountif€� function together with €œand€�
function but I just cant work it out.

Any ideas would be very helpful. Thanks