Cell range in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get the cell range in a formula to automatically increment when I
add a new row? For example, if the formula is =SUM(C3:C8), how do I get the
second cell to change to C9 when I add a new row?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste Formula-dropping 1st cell address 1
Combine rows and Qty 1
Excel VBA 1
Formula Help 4
SUMIF? 2
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Variable Range 3
Range Expression 2

Back
Top