Quote:
Originally Posted by drjogora
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
|
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?