Similar to previous query. Is there anyway to include an operator in an
external reference to a sumproduct formula.

For example, if the formula is =sumproduct((A1:A10=A12)*(B1:B10=B12))

is there any way to have <6 in A12 or 8 in B12? I have figured out how to
include multiple single values but not sure if an operator as described can
exist in a reference cell (probably not since it doesn't seem to work; but is
there a way to do it?)

thanks

anand

Don't think so.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"anand" wrote in message
...
Similar to previous query. Is there anyway to include an operator in an
external reference to a sumproduct formula.

For example, if the formula is =sumproduct((A1:A10=A12)*(B1:B10=B12))

is there any way to have <6 in A12 or 8 in B12? I have figured out how
to
include multiple single values but not sure if an operator as described
can
exist in a reference cell (probably not since it doesn't seem to work; but
is
there a way to do it?)

thanks

anand

No.

If I understand you, this is obvious:
=SUMIF(A1:A100,A12)
=SUMPRODUCT((A1:A100<A12)*(A1:A100B12))