need formula for multiple columns/rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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"



kzas said:
I have a spreadsheet with a budget value in column C, monthly billings in
Click to expand...
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.
 
Back
Top