How do I add a column to a sum formula for every row ie row 1 nee.
 

I need to add a column value (ie column L) to every row. Ie row 1 formula is
sum(A1+B1+C1+D1+E1+F1......) I need to add +L1 to this formula. That is the
easy part. Can I add L1, L2, L3 etc to there corresponding rows at once or
do I have to do each one individually. Ie I have to then manually go to row
2 to add L2 then row 3 to add L3 etc. Looking for a shortcut

If you select the cell with your formaula in it there should be a drag handle
on the bottom right corner, just left mouse click and drag down the rows
required formula will reference automatically.
Hope this helps

"barney" wrote:

I need to add a column value (ie column L) to every row. Ie row 1 formula is
sum(A1+B1+C1+D1+E1+F1......) I need to add +L1 to this formula. That is the
easy part. Can I add L1, L2, L3 etc to there corresponding rows at once or
do I have to do each one individually. Ie I have to then manually go to row
2 to add L2 then row 3 to add L3 etc. Looking for a shortcut

barney, how about puting =SUM(A1+B1+C1+D1+E1+F1+L1) in the first row and
fill down the other rows, will that work for you?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"barney" wrote in message
...
I need to add a column value (ie column L) to every row. Ie row 1 formula
is
sum(A1+B1+C1+D1+E1+F1......) I need to add +L1 to this formula. That is
the
easy part. Can I add L1, L2, L3 etc to there corresponding rows at once
or
do I have to do each one individually. Ie I have to then manually go to
row
2 to add L2 then row 3 to add L3 etc. Looking for a shortcut

=SUM(A1:L1) and copy down

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"barney" wrote in message
...
I need to add a column value (ie column L) to every row. Ie row 1 formula
is
sum(A1+B1+C1+D1+E1+F1......) I need to add +L1 to this formula. That is
the
easy part. Can I add L1, L2, L3 etc to there corresponding rows at once
or
do I have to do each one individually. Ie I have to then manually go to
row
2 to add L2 then row 3 to add L3 etc. Looking for a shortcut