sum product sales figures from another column

[simon]

Hi

I'm totally beaten by this problem so would be eternally grateful if you
could solve this please.

I have one sheet where I list product names in column A and the sales
figures for each product in column B. I then manually type in the top 30 best
selling products in column C. I need to see a total of all sales figures for
the top 30 selling products entered in column C in one cell in column D.

Hopefully that makes sense.

Thanks
Simon

 

[Eduardo]

Hi,
in column D enter

=SUMPRODUCT(--(A:A=C1),B:B)

if you are not using excel 2007 use this one


=SUMPRODUCT(--($A$1:$A$1000=C1),$B$1:$B$1000)

copy formula down

if this helps please click yes, thanks

 

[NBVC]

Hi

I'm totally beaten by this problem so would be eternally grateful i
you
could solve this please.

I have one sheet where I list product names in column A and the sales
figures for each product in column B. I then manually type in the to
30 best
selling products in column C. I need to see a total of all sale
figures for
the top 30 selling products entered in column C in one cell in colum
D.

Hopefully that makes sense.

Thanks
Simon

Try using SUMIF()

e.g

=Sumif(A:A,C1,B:B)

this says to sum all values in column B where column A equals C1..

you can copy down for the other 29 companies

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[simon]

Thanks for your help. I tried the formula but it doesn't total all the sales
figures for the products that match those in column c. Is there a way to do
this?

Thanks

 

[simon]

Thanks for your help. I tried the formula but it doesn't total all the sales
figures for the products that match those in column c. Is there a way to do
this?

Thanks

 

[NBVC]

Did you check the column to make sure the ones that you think ar
matches are exact matches (i.e. not mispelled or having extra spaces
etc..

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[simon]

Hi, yes all matches are correct. The problem is that the figures shown in
column D are individual copies of the product sales figures rather than a
single total in a single cell in column D. I need it to provide a total for
the sales figures of matching product names, is that possible?

Thanks

 

[NBVC]

That is what Sumif should do....

HOW TO GET FURTHER HELP WITH A WORKBOO
For further help with it why not join our forums (shown i
the link below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them. Also i
you do join please post in this thread (link found below) so that peopl
who have been following or helping with this query can continue to d
so. :

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com