View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] christopher.j.denver@googlemail.com is offline
external usenet poster
 
Posts: 6
Default Sum of row and column entries (database)

Hi David,

If you've got your X values in row 1 in B1 to F1, and your Y values in
column A in A2 to A6, then in cell B2 insert the formula =B1+A2. Then copy
that cell to the other cells down and across your range.


Thanks, but this doesn't really do it, as the copying across the sheet
results in Excel changing the cell references accordingly. I could do
it for each column by using the F4 command (fixing cells like $A$1),
but even this is quite lengthy, as I have more than 200 columns and
rows to fill...

Regards,

Chris