Hi All,
I have a requirement to achieve the following using multidimentional array ,
in Excel i can make use of Formula as "=SUMPRODUCT((A:A=1)*(B:B=0))"
But i want to achieve the same using VBA with A:A referring to array column varArrInput1(,4) and B:B refer to varArrInput1(,5)
In short i want to count values if the VarArrInput1(,4) value is equal to 1 and its adjacent value in varArrInput1(,5) value is equal to 0.
Please help