In article ,
Ben wrote:

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

I'd recommend using a Pivot Table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

But if you want to do it with formulae, try:

=SUMPRODUCT(--(A1:A1000="apples"),--(B1:B100=1))

See

http://www.mcgimpsey.com/excel/doubleneg.html

for an explanation.