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.

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.

A pivot table could do this a lot easier. It would count and also add any
values (Revenue) to each of the different products
The count can be treated as such that it will count how manty times the
product appears, or sum together if eachg product line was a number sold.

I.e
Product Quantity ££

Apples 52 15.00
Orange 62 76.00

Etc etc

Matt



HeatherV wrote:
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.

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200809/1

Hi,

Suppose your data is in A1:B1000

Then in column D list each product once starting in D1. You can use the
Advanced Filter, Unique Records command to do that for you.
In cell E1 enter the formula
=COUNTIF(A$1:A$1000,D1)
and fill it down as far as necessary
In cell F1 enter the formula
=SUIF(A$1:A$1000,D1,B$1:B$1000)

--
Thanks,
Shane Devenshire


"HeatherV" wrote:

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.