Hello I am so glad to find this forum, might question might be super easy for most of you but I am beating my head on a wall from last few hours so thought to register and raise it here
I want to Select the month in month total say March it gives me No. 3 and in YTD total is I select Mar 16 from a Drop down say then it gives me sum of 6 and it updates automatically based on the month I select. Index match match or sum index I am not able to get the answer please please help !! I am not able to paste an Image hopefully will learn soon.
Thanks,
<tbody>
</tbody>
<colgroup><col span="14"><col><col></colgroup><tbody>
</tbody>
I want to Select the month in month total say March it gives me No. 3 and in YTD total is I select Mar 16 from a Drop down say then it gives me sum of 6 and it updates automatically based on the month I select. Index match match or sum index I am not able to get the answer please please help !! I am not able to paste an Image hopefully will learn soon.
Thanks,
Name | Jan 16 | Feb 16 | Mar 16 | Apr 16 | Month Total | Year To Date Total | |||||||||
DB | 1 | 2 | 3 | 4 |
<tbody>
</tbody>
<colgroup><col span="14"><col><col></colgroup><tbody>
</tbody>