Jul 29 2022 06:23 AM
I have an Excel sheet with 12 columns and several rows of data. I need to create a column of YTD information that will change depending upon the month. What would my formula be if I change the # in the current month cell "O" so that my ytd # becomes the sum of all the months to that point?
Current Month | 4 | |||||||||||||
Description | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | YTD | |
Revenue | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 800 | 800 | 800 | 800 | ||
COGS | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | ||
Gross Income | 50 | 150 | 250 | 350 | 450 | 550 | 650 | 750 | 750 | 750 | 750 | 750 |
Jul 29 2022 06:31 AM
Jul 29 2022 06:50 AM