V vj1030 New Member Jul 12, 2012 #1 Hi All Need help in following formula., which I have used earlier for some reason not working out Array 1 Array 2 Array3 X 2 1 Y 1 Z 1 3 Y 1 Z 1 3 For above I need sumproduct formula “ sumproduct Array 2 & 3 only if X Vj
Hi All Need help in following formula., which I have used earlier for some reason not working out Array 1 Array 2 Array3 X 2 1 Y 1 Z 1 3 Y 1 Z 1 3 For above I need sumproduct formula “ sumproduct Array 2 & 3 only if X Vj
Faseeh Excel Ninja Jul 12, 2012 #2 Hi vj1030 Use Code: =SUMPRODUCT((Array1="X")*Array2*Array3) Regards, Faseeh
V vj1030 New Member Jul 12, 2012 #3 Thank you Faseeh what if if Array1 name is too long & i need to give = option? i wanted to use = sign to help in larger data. Vj
Thank you Faseeh what if if Array1 name is too long & i need to give = option? i wanted to use = sign to help in larger data. Vj
Faseeh Excel Ninja Jul 12, 2012 #4 vj1030, You want to replace "X" with a cell?? You can always do it with referring to a cell like =SUMPRODUCT((Array1=A1)*Array2*Array3)?? Have i understood your question correctly??
vj1030, You want to replace "X" with a cell?? You can always do it with referring to a cell like =SUMPRODUCT((Array1=A1)*Array2*Array3)?? Have i understood your question correctly??
