Try adding some more parentheses:

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





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

--

Dave Peterson