Problem with SUMPRODUCT.

[bentor]

Hello,

I've got a problem with SUMPRODUCT function. I need to get all products
sold at C8's date, but sort by kind of this products.

A B C D
ID Date Stock Value
1 2005-08-12 copper 28,50
2 2005-09-12 zinc 47,50
3 2005-09-12 zinc 414,54
4 2005-09-11 copper 104,00
5 2005-09-13 steel 213,00

Date: =today()

I used this formula, but it don't work.
=SUMPRODUCT((B2:B6=B8);(C2:C6="steel");(D26))


Looking forward to your thoughts, ideas and suggestions,

Bartosz Dlugokecki.

 

[Bob Phillips]

=SUMPRODUCT(--(B2:B6=TODAY());--(C2:C6="steel");D26)

 

[Guest]

=SUMPRODUCT(--(B2:B6=B8),--(C2:C6="steel"),D26)

Regards,
Bernd

 

[bentor]

Hello,

thank you very much.

It works! =)

Greetings,
Bartosz Dlugokecki.