Hello. I have a sum formula of SUM(B3:F3). I would like to pull it down the column and have it become B4:G4, B5,H5, and so on. Thanks.
Hello. I have a sum formula of SUM(B3:F3). I would like to pull it down the column and have it become B4:G4, B5,H5, and so on. Thanks.
highlight the cell containing the formula, grab the bottom right hand corner and drag it down, if theres data in the cell before it then double clicking the bottom corner will autofill all the cells until the previous column ends.
If someone has helped you then please add to their Reputation
Hi PJ. That's not what I was looking for. I want it to augment a column for each row it goes down. Thanks!!
PJ is correct - the rows will increment as the formula is dragged down.
What happens when you drag the cell down, or use the automatic autofill?
I see now - you want the COLUMN to change, as well as the row, as you drag the formula down and not across!
Thats a whole different situation.
You can probably do this with a helper column to reference as part of your formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks