=SUMPRODUCT((A1:A4= date(2006;03;07))*(C1:C4="OK")*(B1:B4))

The conditions are evaluated as true and false, which is text but if
they are multiplied together they become a value hence the * which you
changed to ;
Also you were missing an opening and closing bracket I have highlighted
all these bits in red.

If you type in the formulan and select a bit of it say
(a1:a4=date(2006;03;07) and press f9 it will show you have it has
evaluted eg true,true false, true then escape will undo. you can do
this to check different bits of the formula if it is not working. It
will be a good test if you have problems with the date.

using the * the following applies to the first 2 conditions
true * true =1
false * false=0
true * false=0
false 8 true= 0

These values multiplied by b1:b4 give you the sum

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=521676