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 |