software

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$318gt;=C123),--($D$137:$D$318lt;=C123 3)

tjquot;carlquot; wrote:

gt; this is part of a sumproduct formula I am using:
gt;
gt; --($D$137:$D$318=C123)
gt;
gt; Is it possible to modify the formula so that it will look for values on C123
gt; between C123 and C123 3 ?
gt;
gt; Thank you in advance.

Hi!

Change that array to:

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

And add another array:

--($D$137:$D$318lt;=C123 3)

Biff

quot;carlquot; gt; wrote in message
...
gt; this is part of a sumproduct formula I am using:
gt;
gt; --($D$137:$D$318=C123)
gt;
gt; Is it possible to modify the formula so that it will look for values on
gt; C123
gt; between C123 and C123 3 ?
gt;
gt; Thank you in advance.