use Sumif for 2 criteria?

Hi guys,
I have a problem,
I have to sum sale amounts according to date and product code. solving this problem with a formula is better for me, but also VBA is possible.
i attach an example worksheet and i hope you can help me...

Hi,

You can't do it with SUMIF, I'm afraid.

The good news is that you can do it with another worksheet function called SUMPRODUCT.

Copy this formula into cell F4.
Then copy it from F4 and paste it into the rest of your summary range.

=-SUMPRODUCT(-($A$4:$A$19>=F$1),-($A$4:$A$19<=F$2),-($B$4:$B$19=$E4),$C$4:$C$19)


Colin

yessss
thank you very very much my friend
i worked 2 hours for this formula, but i never thought to use sumproduct
thanks again...