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)
>