thanks dave and jim, i guess i was close, but not close enough. but at least i
was on the right track

--


Gary


"Jim Thomlinson" wrote in message
...
You need more brackets, something like this...

=SUMPRODUCT((A3:A183="GR")*(I3:I183<0))

--
HTH...

Jim Thomlinson


"Gary Keramidas" wrote:


trying to get the count of values less than zero when a cell ="GR". i thought
this would work, but it doesn't

=SUMPRODUCT(A3:A183="GR")*(I3:I183<0)

can someone point out what's wrong?
--


Gary