thank you all but i can't make it work

"Bob Phillips" wrote:

=SUMPRODUCT(--(A2:A20=--"2006-03-07"),--(C2:C20="Ok"),B2:B20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"yiota" wrote in message
...
i have 3 columns (date, cash and check)

i would like to sum cash if date is eg 07/03/2006 and check is Ok

sorry for my english
thank you