Have a look at COUNTIF in Help
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"HeatherV" wrote in message
...
I need a formula that will enable me to count how many of each product
there
is. For example in one column there could be five different products
appear
several times and in the column next to it I have the amount of product.
I
want the formula to look up the two columns and give me the total of each
product.