Summing two different columns depending on cell values of column A

[tjeastman]

I am trying to compare sales this year compared to last year. I just want Year to date and not pull in all of last year's data to compare to this year.

So on day three of month this is what my spreadsheet looks like.

Column A
Day 1 100
Day 2 100
Day 3 100

Sum(a1:a31) = 300

Column B
Day 1 120
Day 2 201
Day 3 330
....
....
Day 31 333

Sum(b1:b31) = 3099


If its the 3rd day of the month, I only want to look at day 3's data from both this year and last year.

[oeldere]

With a pivot table is it a peace of cake (if your data are formatted well).

[ChemistB]

Assuming Data in Columns A and B starting in Row 2 with new data in Col A

=SUM($B$2:INDEX($B$2:$B$32,Match(999^100,$A$2:$A$32)))
Does that work for you?