New to Excel formulas. I have a row that contains four values in different columns. I perform a SUM within this row. I want to use the same formula in the next row but with the row number bumped up one. Example: =SUM(E3+F3-C3-G3) for row 3. How would I use the ROWS function for the next and succeeding rows? Example?

Thanks, Dave

Just copy the formula down with the little black square at the bottom right of the cell containing the formula.
BTW, just =E3+F3-C3-G3 will do; you dont need the SUM.

Thanks for the reply. I tried that but didn't get the results I was looking for. In the next row I need row numbers to increase by one in order to evaluate the info in that row.

Example
A B C D E F G K
1
2

3 1 1 1 1 0 =E3+F3-C3-G3
4 3 2 3 1 1 you get this result when you copy the formula from k3 down


What do you mean by increasing the rows by 1? What info do you expect the formula in K4 to return?

In Excel, you can use relative or absolute references for both columns and rows. $A1 refers absolutely to column A, A$1 refers absolutely to row 1, $A$1 refers absolutely to cell A1, etc.

When you copy the cell/range, using copy-paste, copy-paste special>formulas, or dragging e.g. down or to right from lower rihgt edge of cell/range, absolute references don't change, but relative references do change.
P.e. when in cell X3 you have a formula =SUM($E3:$F3)-SUM($C3,$G3), and you copy the this to cell X4, the formula in X4 will be =SUM($E4:$F4)-SUM($C4,$G4). When you copy X3 to Z3, the formula in C3 will be =SUM($E3:$F3)-SUM($C3,$G3) - the formula doesn't change, as the row is same, and column references are absolute.

I have attached a sample for clarity. In cell H4, what is the value that you want the formula to return?

Attached Files

Sample.xlsx (8.5 KB, 7 views)

See video. The mouse hasn't recorded in exactly the right position, the little green square was dragged down.

Can't upload this file so here's a link to it:
https://www.dropbox.com/s/tsarm6givo...35_41.mp4?dl=0