Sumproduct Q
 

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)

Sumproduct Q
 

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


--
Don Guillett
SalesAid Software

"Sean" wrote in message
oups.com...

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)

Sumproduct Q
 

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

"Sean" wrote:


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)

Sumproduct Q
 

Try
=SUMPRODUCT(--(J16:J33=0.21),--(M16:M33=2000),I16:I33,J16:J33)

Hutch

"Sean" wrote:


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)

Sumproduct Q
 

On Apr 26, 5:16 pm, Tom Hutchins
wrote:
Try
=SUMPRODUCT(--(J16:J33=0.21),--(M16:M33=2000),I16:I33,J16:J33)

Hutch



"Sean" wrote:

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)- Hide quoted text -

- Show quoted text -

Thanks all for your replies