sum product sales figures from another column
 

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

sum product sales figures from another column
 

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



"simon" wrote:

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

sum product sales figures from another column
 

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

"Eduardo" wrote:

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



"simon" wrote:

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