Sumproduct Q

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)
 
D

Don Guillett

try
=SUMPRODUCT(--(J16:J33=0.21),--(M16:M33=2000),I16:I33)
or
=SUMPRODUCT((J16:J33=0.21)*(M16:M33=2000)*I16:I33)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top