countif multiplication problem

[gravedodger]

Hi there ... I'm new and just found this forum and I've already found some answers to other formula problems but this one still alludes me :x

I need some sort of a CountIf formula to count the number of products in a given column multiplied by the quantity needed of that product.

excuse the next bit of gibberish

So cell A:1 reports =COUNTIF(D3:D600,"product") multiplied by the adjacent cell that has the quantity required by the customer.

clear as mud eh !

 

[Oaktree]

Welcome to the board!

Try = sumproduct(--(D3:D600="product"),E3:E600)

 

[gravedodger]

Thanks for the superfast reply Oaktree but no joy .... but maybe I should have added the in the 2 columns there are rows of different products and different quantities for each.

 

[Oaktree]

This sounds like a job for a pivot table. Can you use a PT to group your items by customer and product and sum by quantity? Or is that not what you're after...

 

[gravedodger]

Hold on Sir .... my apologies ... your solution works perfectly Oaktree it was my hack-handed typing was the problem.

Cheers buddy

 

[Aladin Akyurek]

Welcome to the board!

Try = sumproduct(--(D3:D600="product"),E3:E600)

Why get unnecessarily expensive when

=SUMIF(D3:D600,"product",E3:E600)

will do?

Addendum. Superfluous paren removed...

 

[Oaktree]

Welcome to the board!

Try = sumproduct(--(D3:D600="product"),E3:E600)

Why get unnecessarily expensive when

=SUMIF(D3:D600,"product"),E3:E600)

will do?

Yeah, yeah. Old habits.

 

[Scott Huish]

There's an extra parenthesis in there, try this one:

=SUMIF(D3:D600,"product",E3:E600)