#1
|
|||
|
|||
Assistance with the ROWS function
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 |
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
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.
|
#4
|
||||
|
||||
Quote:
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? |
#5
|
|||
|
|||
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. |
#6
|
||||
|
||||
Quote:
|
#7
|
||||
|
||||
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 |
Tags |
rows |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Assistance with Today() function returning correct value | DaveWSinger | Excel | 4 | 03-08-2018 05:34 AM |
Assistance with Word VBA | nanders8 | Word VBA | 3 | 05-04-2017 10:39 PM |
MODE function excluding hidden rows | michael_1962 | Excel | 1 | 05-21-2015 10:09 PM |
AVERAGEIF function excluding hidden rows | michael_1962 | Excel | 1 | 05-17-2015 11:31 PM |
a function that deletes all rows with no value in a certain column? | dunndealpr | Excel | 2 | 06-08-2013 06:50 AM |