Assistance with the ROWS function

Marcia · #4 10-26-2018, 10:40 PM

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?

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