Good evening, I need your help, I got stuck comparing the sum of 2 years.

In the attached file I have some lines that I don't need for the request and to make the file more readable

In the Sales Volune sheet I have the months (I put only 3) and 2 years the current one on the left and the previous year on the right.

I would like to compare the H-I column values with those of the N-O column of the Sales sheet.

In Sheet 3 in column F-G I created the dates of beginning weekend for current year F and previous year column G

in F123 I entered the date to stop the calculation.

In H122 and below in the other weeks there is the formula that works correctly for the current year.

What I need is the formula in N122 similar to the one in H122 that does the same calculation but for the column N Sales Volume sheet and relative to the previous year.

The year changes to L120 Sales sheet.

I hope I explained to you if it is not clear, just ask

thank you.

## Bookmarks