Thread: Sumproduct Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default 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)