Hi,
I have 2 tables in 2 sheets.
Sheet1
<tbody>
</tbody>
Sheet2
<tbody>
</tbody>
Result:
In B2 (Table Sheet1), I would like to have: sum column F (Table sheet2), <= Today date (dynamic), if column E (Table sheet2) is matching column A (Table sheet1) and it is the current month.
In C2 (table Sheet1), same per above, but sum of column G (Table sheet2)
In D2 (Table Sheet1), I would like to have: sum column F (Table sheet2), <= Today date (dynamic), if column E (Table sheet2) is matching column A (Table sheet1) and it is the current quarter or Q2.
In E2 (table Sheet1), same per above, but sum of column G (Table sheet2)
I tried to use helper column/cell but I am not able to find a solution by myself. Any help?
Thank you
I have 2 tables in 2 sheets.
Sheet1
name | Margin MTD | Target MTD | Margin QTD | Target QTD |
James | ||||
Mark | ||||
Frank | ||||
Jim | ||||
Russell | ||||
Conrad | ||||
Denis |
<tbody>
</tbody>
Sheet2
Year | Quarter | Month | Day | Name | Margin | Target |
2018 | Q2 | May | 01-05-2018 | James | 10 | 20 |
2018 | Q2 | May | 01-05-2018 | Mark | 20 | 20 |
2018 | Q2 | May | 01-05-2018 | Frank | 25 | 15 |
2018 | Q2 | May | 01-05-2018 | Jim | 31 | 30 |
2018 | Q2 | May | 02-05-2018 | James | 23 | 22 |
2018 | Q2 | May | 02-05-2018 | Mark | 4 | 18 |
2018 | Q2 | May | 02-05-2018 | Frank | 100 | 66 |
2018 | Q2 | May | 02-05-2018 | Jim | 32 | 41 |
2018 | Q2 | May | 02-05-2018 | Russell | 11 | 40 |
2018 | Q2 | May | 02-05-2018 | Conrad | 23 | 20 |
2018 | Q2 | May | 03-05-2018 | Mark | 67 | |
2018 | Q2 | May | 03-05-2018 | Denis | 33 | |
2018 | Q2 | June | 05-06-2018 | Mark | 20 | |
2018 | Q2 | June | 05-06-2018 | Frank | 10 | |
2018 | Q2 | June | 05-06-2018 | Jim | 4 | |
2018 | Q2 | June | 05-06-2018 | James | 3 |
<tbody>
</tbody>
Result:
In B2 (Table Sheet1), I would like to have: sum column F (Table sheet2), <= Today date (dynamic), if column E (Table sheet2) is matching column A (Table sheet1) and it is the current month.
In C2 (table Sheet1), same per above, but sum of column G (Table sheet2)
In D2 (Table Sheet1), I would like to have: sum column F (Table sheet2), <= Today date (dynamic), if column E (Table sheet2) is matching column A (Table sheet1) and it is the current quarter or Q2.
In E2 (table Sheet1), same per above, but sum of column G (Table sheet2)
I tried to use helper column/cell but I am not able to find a solution by myself. Any help?
Thank you