Thread: Copying Formula
View Single Post
  #3  
Old November 18th, 2009, 06:50 PM posted to microsoft.public.excel.misc
Pete_UK
external usenet poster
 
Posts: 8,780
Default Copying Formula

Put this in C1:

=SUM(A1,B$1:B$10)

and then copy down to C10.

Hope this helps.

Pete

On Nov 18, 6:26*pm, musab wrote:
I have a spreadsheet. Column A, B and C. *Rows 1-10
I have numbers in A and B. *In column C, I want a formula to calcutate the
sum of B+A1 in all the rows. *Please help. *Remember I just want the sum of
column B for A1 only.

Thanks