Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How do i make a column the sum of others, so for example i want to make what appears in column F for every row the sum of A-E. I suppose that i am asking is there a wildcard character to indicate the current row

ie something like =sum(A*:E*)

share|improve this question

migrated from stackoverflow.com Jan 14 '13 at 14:00

This question came from our site for professional and enthusiast programmers.

    
A excel sheet can go all the way up to 99999999 rows. Do you really want a * ? –  taxeeta Jan 14 '13 at 10:33

1 Answer 1

up vote 3 down vote accepted

You can "copy down" a formula and the references will change automatically, so if you use this formula in F2

=SUM(A2:E2)

then you can copy that down the column and the references will update to match each row.

Copying the formula down works similar in Google docs to excel. If you put the cursor on the bottom right of the cell [containing first formula] you can hold down left mouse and drag down as far as you need........or you can simply double-click left mouse and the formula will populate as far down the column as you have continuous data in the adjacent column

share|improve this answer
    
boom done, cheers –  Jock Mahon Jan 14 '13 at 12:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.