If your data is in a1:g5 so coupon1 is in a3

and the parameters you are wishing to match are coupon in a7, date in
a8, value in a9

try something like

=SUMPRODUCT((B1:G1=A8)*(B2:G2=A9)*OFFSET(B2,MATCH( A7,A3:A5,0),0,1,6))

Regards

Dav


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