View Single Post
  #1   Report Post  
MediaScribe
 
Posts: n/a
Default Automatically 'incrementing' formulas for new rows.

Here's my question. I am making a 'scoring' sheet for an online game. It is
set up essentially as such...

A B C
D
1 (Player Name) (Question #1 Points) (Question #2 Points) =SUM(B1:C1)

2 (Player Name) (Question #1 Points) (Question #2 Points) XXXXXXX

I would like D in each Row to add the sum of the previous two Columns for
each player (represented by XXXXXXX). Do I need to manually input each
formula for D? I have over 100 players and this will take forever! Is there
any way to have D's formula automatically increment the row numbers from the
previous row as I add players? (So the formula in D2 would automatically
update to =SUM(B2:C2) )
Did I explain that clearly enough? I hope so. Thanks for any help anyone
can give.