I think he want D2 to hold the = as well Don, or say "1400"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Don Guillett" wrote in message
...
of course,
=sumproduct((a2:a22=d2

--
Don Guillett
SalesAid Software

"John V" wrote in message
...
SUMIF allows one to enter a [valid] criteria text string into cell D2,
say
"14000", and then reference D2 as the function criteria, e.g.,
=SUMIF(B5:B10,D2,C5:C10).

Is there a syntax that SUMPRODUCT will accept that does the same thing?
Note
the inclusion of a comparison operator is important.

Thanks! JV