View Single Post
 
Old 10-26-2018, 10:48 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by drjogora View Post
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
I have attached a sample for clarity. In cell H4, what is the value that you want the formula to return?
Attached Files
File Type: xlsx Sample.xlsx (8.5 KB, 9 views)
Reply With Quote