Hi David
My apologies.
Because I was copying and pasting from your formula with the AND in it,
I inadvertently left a stray ")" in there after the B range
It should be
=SUMPRODUCT(--($B$7:$B$10070=1770),
--(YEAR($E$7:$E$10070)=2006),
$H$7:$H$10070)

I have deliberately split the formula after the commas, to try to avoid
any funny wraps in posting.

--
Regards

Roger Govier


"OSDavidL" wrote
in message ...

Roger,

Thanks, it looks Ok but I get a "formula contains an error" message
with the last H10070 highlighted. Your logic looks good but I can't
see
why it does not work. Any suggestions?

Rgs

David


--
OSDavidL
------------------------------------------------------------------------
OSDavidL's Profile:
http://www.excelforum.com/member.php...o&userid=31305
View this thread:
http://www.excelforum.com/showthread...hreadid=509961