Thanks Don, but that doesn't get around my lookup part of the problem.
Don Guillett wrote:
not too clear on your needs but try this idea
=sumproduct((month(daterange)=2)*datarange)