| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to stop formulas from incrementing when you copy and paste? | Excel Worksheet Functions | |||
| How do I stop an Excel sheet from automatically hiding rows when . | Excel Worksheet Functions | |||
| How do I automatically hide rows | Excel Discussion (Misc queries) | |||
| Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
| Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
Threaded Mode
