Hello,

I have entered daily visitors and in a spreadsheet, with each cell representing the amount of visitors by day (b3 = 100, c3 = 50, d3 = 20 etc). The date for each day is entered in row 2 (b2, c2, d2, etc...)

I would like sum this data weekly and monthly in cells and display it on another sheet. When I try using =sum(a3:h3) then I drag it horizontally, the next cell shows (b3:i3) when i want it to show (i3:o3), how can i do this?

I would also like to show in a different cell, the month to date totals. For example on July 14th, I would like the cell to tell me all of my visitors in July.

Thanks!