Excel 2013/2016
<tbody>
</tbody>
Hi all,
Would like to check on formula for G7 & H7.
Cell F3 is drop down menu which for me to select data for particular month.
For example, if I select Month = Mar18.
Cell G7 (monthly data) would reflect sales for Mar18, which is $3800
Cell H7 (year-to-date data) would reflect total sales from Jan18 to Mar18, which is $6900
A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | Trial Balance | |||||||
2 | ||||||||
3 | Jan18 | Feb18 | Mar18 | Month | Feb18 | |||
4 | $ | $ | $ | |||||
5 | Sales | 100 | 600 | 1100 | Month | Year-To-Date | ||
6 | Sales | 200 | 700 | 1200 | $ | $ | ||
7 | Purchase | 300 | 800 | 1300 | Sales | 2300 | 3100 | |
8 | Purchase | 400 | 900 | 1400 | ||||
9 | Sales | 500 | 1000 | 1500 | Month | Mar18 | ||
10 | ||||||||
11 | Month | Year-To-Date | ||||||
12 | $ | $ | ||||||
13 | Sales | 3800 | 6900 |
<tbody>
</tbody>
Sheet1
Hi all,
Would like to check on formula for G7 & H7.
Cell F3 is drop down menu which for me to select data for particular month.
For example, if I select Month = Mar18.
Cell G7 (monthly data) would reflect sales for Mar18, which is $3800
Cell H7 (year-to-date data) would reflect total sales from Jan18 to Mar18, which is $6900