D
drakey
I have a worksheet that shows the spending from Mon-Fri for each week of the
year. So the worksheet is similiar to:
Mon Tues Wed Thurs Fri Mon Tues Wed etc.
On a seperate worksheet I want to total each, so I am currently using the
=sum(A1:E1). I am doing this for each week, so week two would be =sum(F1:J1).
I want to be able to just copy the formula across, instead of typing it over
and over, but when I try to copy, I end up with =sum(B1:F1). I know there
should be a way to do it.
Thanks!
year. So the worksheet is similiar to:
Mon Tues Wed Thurs Fri Mon Tues Wed etc.
On a seperate worksheet I want to total each, so I am currently using the
=sum(A1:E1). I am doing this for each week, so week two would be =sum(F1:J1).
I want to be able to just copy the formula across, instead of typing it over
and over, but when I try to copy, I end up with =sum(B1:F1). I know there
should be a way to do it.
Thanks!