help with sumproduct
 

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

help with sumproduct
 

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

help with sumproduct
 

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

help with sumproduct
 

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