Sumproduct If Q

John · Mar 24, 2005

I am trying to multiple columns J x I if Column J = 0.135. I've used the
following but I'm getting a #Value! error - any ideas

Thanks

=SUMPRODUCT(--(J16:J28=0.135),(I16:I28,J16:J28))

Dave Peterson · Mar 24, 2005

How about:

=SUMPRODUCT(--(J16:J28=0.135),(I16:I28),(J16:J28))

JulieD · Mar 24, 2005

Hi John

try
=SUMPRODUCT(--(J16:J28=0.135),(I16:I28*J16:J28))

cheers
JulieD

John · Mar 24, 2005

Thanks Dave

Dave Peterson said:
How about:

=SUMPRODUCT(--(J16:J28=0.135),(I16:I28),(J16:J28))