SumProduct Formula

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" <carl@discussions.microsoft.com> wrote in message
news:B2DEEB67-C1D9-4AC2-83BB-43904DF2E644@microsoft.com...
> 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.