View Single Post
  #1   Report Post  
barney
 
Posts: n/a
Default 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