How about

--($D$137:$D$318=C123),--($D$137:$D$318<=C123+3)

tj


"carl" wrote:

this is part of a sumproduct formula I am using:

--($D$137:$D$318=C123)

Is it possible to modify the formula so that it will look for values on C123
between C123 and C123+3 ?

Thank you in advance.