Calculating Year to Date Totals

Sam Lugiano

I would like to automate the calculation of weekly totals from the previous year (2019) so that I can compare them to current year (2020). In order to do this I need to automate the calculation of the previous year's total by the current week number. The screen shot shows the totals by week from 2019 with the week number on top. Your help is appreciated.

Best,

Sam

MCorbin

Can you provide a screenshot of the sheet with the data in it? (blur out any PHI, naturally). I really only care about the headers. That will help with creating the formula....

Sam Lugiano

The YTD 2019 of 37,695 is just a SUM formula that I drag to current week. I would like to have it automatically calculate the current week. I tried using the IF(WEEKNUMBER(TODAY() before the SUM formula but couldn't get it to work. Please let me know if you cannot see the sheet below. Thank you.