Salamullah
Board Regular
- Joined
- Mar 28, 2011
- Messages
- 221
Please help I need formula to bring result in cell A4 based on the change condition in A1, A2 & A3 from the array B1:F10.
<colgroup><col width="64" style="width:48pt" span="6"> </colgroup><tbody>
</tbody>
A | Area | Source | Jan | Feb | Mar |
Jan | A | Imp | 1 | 2 | 1 |
Imp | B | Imp | 1 | 2 | 4 |
C | Imp | 1 | 2 | 4 | |
A | loc | 6 | 2 | 4 | |
B | loc | 1 | 3 | 4 | |
A | Imp | 1 | 3 | 4 | |
C | loc | 2 | 2 | 2 | |
C | loc | 2 | 2 | 2 | |
A | Imp | 2 | 2 | 2 |
<colgroup><col width="64" style="width:48pt" span="6"> </colgroup><tbody>
</tbody>