Enter the item in D1, and the date to match in D2, with the date containing
column as B:

=SUMPRODUCT((A1:A100=D1)*(B1:B100=D2)*C1:C100)

With this formula, you can't use total column references (A:A, B:B ...etc.).

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Jrr6415sun" wrote
in message ...

thank you very much

what if i want 2 criteria like in one column it has to be a pin and in
the other column it has to be the right date. Is there a way to do
this?


--
Jrr6415sun
------------------------------------------------------------------------
Jrr6415sun's Profile:
http://www.excelforum.com/member.php...o&userid=25064
View this thread: http://www.excelforum.com/showthread...hreadid=385838