adding various numbers to value of one cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Boze - 01 Jun 2007 20:10 GMT

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 to this Message

Don Guillett - 01 Jun 2007 20:09 GMT

one way>copy c1>select the cells to goto>edit>pastespecial>add

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>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 to this Message

Gord Dibben - 01 Jun 2007 21:32 GMT

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

>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 to this Message

Boze - 05 Jun 2007 16:38 GMT

Thank you both. Those worked great!

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 to this Message

Don Guillett - 05 Jun 2007 23:22 GMT

glad it helped

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Thank you both. Those worked great!
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message