Forum Discussion

SubhasisB's avatar
SubhasisB
Copper Contributor
Aug 22, 2020
Solved

Sumproduct with 3 conditions

Hello Friends, can you please help regarding the attached file, where I have 3 conditions for sumproduct function, I am getting zero answer, please help.
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 22, 2020

    SubhasisB 

    Another variant is

    =SUMPRODUCT(
   Data!C3:AO13,
   ( (Data!C1:AO1=Ans!A2) +
     (Data!D1:AP1=Ans!A2) +
     (Data!E1:AQ1=Ans!A2)
   ) *
   (Data!C2:AO2=Ans!B2)*
   (Data!A3:A13=Ans!C2)
)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 22, 2020

SubhasisB 

Another variant is

=SUMPRODUCT(
   Data!C3:AO13,
   ( (Data!C1:AO1=Ans!A2) +
     (Data!D1:AP1=Ans!A2) +
     (Data!E1:AQ1=Ans!A2)
   ) *
   (Data!C2:AO2=Ans!B2)*
   (Data!A3:A13=Ans!C2)
)

Resources