excel fomula help?

Question

hi guys. im new to excel and need some help with creating a formula. i have a sheet in which all rows in columns 'C' to 'E' contain numbers. i want the rows in column 'F' to contain the total of the numbers in columns C to E in that same row. for example, in row 2, i want f2 to contain the total of c2 to e2. in row 3 i want f3 to contain the total of c3 to e3. how do i do this without having to type in a formula for each cell in column f? in other words, is it possible to make a formula which will make all the cells in column f calculate the sum of columns c to e in that row. please and thank you.

Answer 1

1)Click on a cell in column F.
2)Type =
3)Click and drag from the corresponding cell in C to E.
If you don't want D included, click on C and E while holding the Ctrl button.
4)Press Enter
5)You will now see the sum of C,E and whatever else you select in column F. Now click the small black box that's at the bottom right corner of the newly formed cell in F, and drag this as far down as you have data. The same formula will now apply for all of these newly selected cells.
Enjoy.

Answer 2

Use the auto sum button. It looks like a strange letter E or the Greek sigma.

Click it in the cell that you want the total for, then drag your mouse through the cells that you want totaled, then hit enter.

If you click back on the cell that has to total, you can use the auto fill handle (it is on the bottom right of the selected cell). Click it and drag down the column where you want all the totals to appear, then the formula will be copied for the remaining rows.

Answer 3

The formula to be input into column F for the total of row 1, columns A-E is:

=SUM(A1:E1)

For row 2 you just change the "1" to "2" resulting in
=SUM(A2:E2)

Answer 4

Highlight the cells you want to add, then click the "Sum" button. this should create the formula for you. You can then click on the cell with the formula, grab the bottom right corner, and drag it down to copy that formula to the rest of the rows.

Answer 5

increasing upon the respond appropriate to the $ getting used to grant absolute addressing: assume you have, in cellular E2 of your spreadsheet, the formula =SUM(A2:C2). Now, assume you reproduction the formula from cellular E2 to cellular C4. you will get a #REF! errors, because of the fact the formula can't reference the cells after this is been moved. We have been utilising relative addressing -- in different words, we've been asserting, "get the values from the 1st 3 columns to the left"; for the reason that we moved the formula into one among those first 3 columns, we've a conflict with the referenced columns. even with the incontrovertible fact that, in case you replace the formula in cellular E2 to be =SUM($A$2:$C$2), you may paste it from cellular E2 to cellular C4, and it will return the right sum -- because of the fact we are making absolute connection with the cells, relatively than relative references to the cells.