SumProduct Formula

[Guest]

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.

 

[Guest]

How about

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

tj

 

[Biff]

Hi!

Change that array to:

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

And add another array:

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

Biff