Surbhi_baphna
New Member
- Joined
- Oct 19, 2018
- Messages
- 2
Hi ,
I want to incorporate Sumifs formula where my sum range is dynamic basis the given criteria.
For ex :
In below data, i want to find sum of Sample 2 , for Business A and level 1 as my criteria. and sum should be for all YTD columns, so in case i change June as YTD, sum should include June as well. Pls help, waiting for answer...
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
I want to incorporate Sumifs formula where my sum range is dynamic basis the given criteria.
For ex :
In below data, i want to find sum of Sample 2 , for Business A and level 1 as my criteria. and sum should be for all YTD columns, so in case i change June as YTD, sum should include June as well. Pls help, waiting for answer...
YTD | YTD | YTD | YTD | YTD | YTD | 0 | 0 | 0 | |
Bus A | Bus A | Bus B | Bus A | Bus A | Bus B | Bus A | Bus A | Bus B | |
Level 1 | Level 2 | Level 1 | Level 1 | Level 2 | Level 1 | Level 1 | Level 2 | Level 1 | |
Apr | Apr | Apr | May | May | May | June | June | June | |
Sample 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Sample 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
Sample 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>