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.

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.

Hi!

Change that array to:

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

And add another array:

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

Biff

"carl" wrote in message
...
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.