SumProduct Formula

C

carl

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.
 
B

Biff

Hi!

Change that array to:

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

And add another array:

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

Biff
 
Top