Hi all,
First time posting on this forum and i am looking for help. I have two different tables and I need to calculate total to date values based on current month so i guess i have to use sumif with index match.
table 1:
<tbody>
</tbody>
table 2:
<tbody>
</tbody>
What i am trying to do is once i change current month from 2 to 3 for example the formula will automatically calculate the summation of that row in table 2 for item 100 for example. Could you guys help me form the formula? i have tried combinations of sum/sumif/sumifs with index match but without success.
Thanks!
First time posting on this forum and i am looking for help. I have two different tables and I need to calculate total to date values based on current month so i guess i have to use sumif with index match.
table 1:
A | B | |
1 | current month: M3 | total to date |
2 | 100 | ? |
3 | 111 | |
4 | 102 | ? |
<tbody>
</tbody>
table 2:
A | B | C | D | E | |
1 | current month: 3 | M1 | M2 | M3 | M4 |
2 | 100 | 12 | 123 | 32 | 43 |
3 | 101 | 23 | 234 | 53 | 55 |
4 | 103 | 23 | 45 | 66 | 54 |
<tbody>
</tbody>
What i am trying to do is once i change current month from 2 to 3 for example the formula will automatically calculate the summation of that row in table 2 for item 100 for example. Could you guys help me form the formula? i have tried combinations of sum/sumif/sumifs with index match but without success.
Thanks!