Good morning,
I am looking a 100 loop to perform the following calculation:
Formula =SUMPRODUCT(--(Data!A$2:A$5000=A$26),--(Data!C$2:C$5000=A39),Data!D$2:D$5000) which is located in Sheet2!A39:A43.
Next block is from 23 rows down, A62:A66 using the same Sumproduct formula. But the first criteria becomes A$49, 23 rows down from A$26.
There are 100 blocks repeating at 23 rows step.
Any help would be appreciated.
Dennis
I am looking a 100 loop to perform the following calculation:
Formula =SUMPRODUCT(--(Data!A$2:A$5000=A$26),--(Data!C$2:C$5000=A39),Data!D$2:D$5000) which is located in Sheet2!A39:A43.
Next block is from 23 rows down, A62:A66 using the same Sumproduct formula. But the first criteria becomes A$49, 23 rows down from A$26.
There are 100 blocks repeating at 23 rows step.
Any help would be appreciated.
Dennis
