It worked! Thanks so much.

& thanks to everyone else for helping me, I appreciate it.

Roger Govier Wrote:
Hi

Try
=SUMPRODUCT(--(B2:B1589="BCN"),--(C2:C1589="Yes"),E2:E1589)
assuming values in E2:E1589 are numeric.

--
Regards

Roger Govier



--
jlhart76
------------------------------------------------------------------------
jlhart76's Profile: http://www.excelforum.com/member.php...o&userid=30274
View this thread: http://www.excelforum.com/showthread...hreadid=499413