Forum Discussion
Question regarding sum a range of cells
Hi, I'm using Microsoft Excel Office 365 and have a spreadsheet containing two sheets, one sheet with the sales of each day and one sheet displaying the sales per week. The sheet that displays th...
One uses ROW() if the formula is to be copied down. Since you copy to the right, you need to use COLUMN(). And since the first formula is in the first column, use COLUMN()-1
=SUM(OFFSET('sales per day'!$B$2,0,(COLUMN()-1)*7,1,7))
Hi Hans! Thanks alot for your reply.
I'm trying to use this formula to my actual data set now but can't manage to get it right.
The range I want to sum for week 1 2023 is here:
Sheet: 13 week forecast
Cell: CCY12:CDE12
The cell I want the sum for week 1 in:
Sheet: Week-to-week
Cell: BD4
The range I want to sum for week 2 2023 is here:
Sheet: 13 week forecast
Cell: CDF12:CDL12
The cell I want the sum for week in:
Sheet: Week-to-week
Cell: BE4
Which formula should I use in cell BD4 (sheet Week-to-week) and which formula should I use in cell BE4 (sheet Week-to-week)?
I'm trying to use this formula to my actual data set now but can't manage to get it right.
The range I want to sum for week 1 2023 is here:
Sheet: 13 week forecast
Cell: CCY12:CDE12
The cell I want the sum for week 1 in:
Sheet: Week-to-week
Cell: BD4
The range I want to sum for week 2 2023 is here:
Sheet: 13 week forecast
Cell: CDF12:CDL12
The cell I want the sum for week in:
Sheet: Week-to-week
Cell: BE4
Which formula should I use in cell BD4 (sheet Week-to-week) and which formula should I use in cell BE4 (sheet Week-to-week)?