| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
adding various numbers to value of one cell
one waycopy c1select the cells to gotoeditpastespecialadd
-- Don Guillett SalesAid Software "Boze" wrote in message ... I need to add different numbers in column A to the value in C1. (A1+C1, A2+C1, A3+C1, etc). Is there an easy way to get Excel to do this without having to manually input the formula in each cell? Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
adding various numbers to value of one cell
I need to add different numbers in column A to the value in C1. (A1+C1,
A2+C1, A3+C1, etc). Is there an easy way to get Excel to do this without having to manually input the formula in each cell? Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
adding various numbers to value of one cell
Boze
In B1 enter =A1+$C$1 and drag/copy down. If you have data in column A, just double-click on the fill handle of B1 and will copy down without dragging. The A1 will increment but the $C$1 will remain absolute. Gord Dibben MS Excel MVP On Fri, 1 Jun 2007 12:25:15 -0700, "Boze" wrote: I need to add different numbers in column A to the value in C1. (A1+C1, A2+C1, A3+C1, etc). Is there an easy way to get Excel to do this without having to manually input the formula in each cell? Thanks |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Thanks!
Thank you both. Those worked great!
"Boze" wrote in message ... I need to add different numbers in column A to the value in C1. (A1+C1, A2+C1, A3+C1, etc). Is there an easy way to get Excel to do this without having to manually input the formula in each cell? Thanks |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Thanks!
glad it helped
-- Don Guillett SalesAid Software "Boze" wrote in message ... Thank you both. Those worked great! "Boze" wrote in message ... I need to add different numbers in column A to the value in C1. (A1+C1, A2+C1, A3+C1, etc). Is there an easy way to get Excel to do this without having to manually input the formula in each cell? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding numbers shown in cells, not what is actually in cell - help!!! | Excel Worksheet Functions | |||
| adding numbers in each cell | Excel Discussion (Misc queries) | |||
| Adding numbers to a Time Formated cell | Excel Discussion (Misc queries) | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| Adding numbers in a single cell | Excel Worksheet Functions | |||
Linear Mode
