need formula for multiple columns/rows

[Guest]

I have a spreadsheet with a budget value in column C, monthly billings in columns D - Q, and the remaining balance in column R. I can use =c3-sum(d3:q3) for row 3, but is there a formula to repeat the calculation for multiple rows without having to type that into the R cell on every row. I'm sure it is simple, I'm just learning.
Thanks,
kzas

 

[LoucaGreen]

Hi Kzas,

If I got it right, you want the formula to calculate the sum for al
the rows from row 3 up to the row is appears. If so, then the followin
should do it:

=$c$3-sum($d$3:$q3)

-(assuming that there is only one budget figure)-

=$c$3-sum(d$3:q3 should work also.

Use the $ sign for whatever you want to remain constant.

So, it row 10 for example your formula will become
=$c$3-sum($d$3:$q10)

I hope this is what you were after.

Good luck

Louca

 

[AlfD]

Hi!

One of Excel's most important and powerful features is copy-down.

Click on R3. Move your cursor to the right bottom corner of the cell
When the cursor becomes a solid *+* , left-click and hold it: then dra
it down the column. This should populate the column with replicas of R
except the 3's in the formula will increase by 1 each row you go down
If it's tricky to begin with when you try to grab the copy handle, tr
zooming to a higher screen magnification.

Otherwise: use copy and paste. Copy R3. Then select R4 to R 100 (say)
Now paste. There are so many ways of doing that, you need to read up o
it. Start with the Help file.

You can also copy across. Also read about Fill Down and Fill Across.

Al

 

[Andy Wiggins]

Copy the formula down to the other cells in R.

Here are two ways to be getting on with:

1) You can use Edit > Copy, then highlight the target area and use Edit >
Paste.

2) Make the cell containing the formula the active cell. On the bottom right
of that cell is a little black box. Click on it and whilst holding the mouse
button down, drag it to the cells below

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

I have a spreadsheet with a budget value in column C, monthly billings in

columns D - Q, and the remaining balance in column R. I can use
=c3-sum(d3:q3) for row 3, but is there a formula to repeat the calculation
for multiple rows without having to type that into the R cell on every row.
I'm sure it is simple, I'm just learning.

 

[Guest]

Thanks