S
Sean
I am trying to create a SUMPRODUCT formula that will multiply I16:I33
x J16:J33, but only if -
J16:J33 = 0.21
AND
M16:M33 = 2000
Formula below is wrong, perhaps someone can direct me
Thanks
=SUMPRODUCT(--(J16:J33=0.21),(M16:M33=2000),I16:I33)
x J16:J33, but only if -
J16:J33 = 0.21
AND
M16:M33 = 2000
Formula below is wrong, perhaps someone can direct me
Thanks
=SUMPRODUCT(--(J16:J33=0.21),(M16:M33=2000),I16:I33)