Hi Experts,
Requesting your help...
I am working on a table where in I need to get value based on sumproduct of two columns. One set of column values should be taken from array based on specific condition...
A, B, C is array which should be picked up for sumproduct, based on E1-K1 values.....For E n F, we should select Array A2:A7, for G, H it should be B and for J, K it should be C
Requesting your help...
I am working on a table where in I need to get value based on sumproduct of two columns. One set of column values should be taken from array based on specific condition...
A, B, C is array which should be picked up for sumproduct, based on E1-K1 values.....For E n F, we should select Array A2:A7, for G, H it should be B and for J, K it should be C
A | B | C | D | E | F | G | H | I | J | K | |
1 | FY22 | FY23 | FY23-1 | FY22 | FY22 | FY23 | FY23 | FY23-1 | FY23-1 | FY23-1 | |
2 | 1 | 10 | 100 | MAR | APR | MAY | JUN | JUL | AUG | SEP | |
3 | 2 | 20 | 200 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
4 | 3 | 30 | 300 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
5 | 4 | 40 | 400 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
6 | 5 | 50 | 500 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
7 | 6 | 60 | 600 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||
8 | |||||||||||
10 | Total | 21 | 21 | 210 | 210 | 2100 | 2100 | 2100 |