Thread
:
Sumproduct Q
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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)
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett