| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make 1 cell the SUM of other cells in the row, for whole column?
D581 has the formula =SUM(G581:X581)
and so on for other rows, done by Select then Copy, then selecting many rows in col D. Then Paste - formulas. This of course has to be repeated to extend the same formula to apply to more rows. Can I just select Column D then apply the formula once and it applies to all rows of col D? Excel 2007 The formula tab doesn't see to help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a range of cells in a column equal to another cell | New Users to Excel | |||
| My column cell values are -ve how do I make all cell value +ve, | Excel Worksheet Functions | |||
| How do I make 2 cells become one without changing column size | Excel Discussion (Misc queries) | |||
| How do I make email addresses in a column of cells active links? | Excel Discussion (Misc queries) | |||
| Make new column using partial text in another cell | Excel Worksheet Functions | |||
Threaded Mode
