ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Summing numbers (https://www.excelbanter.com/excel-discussion-misc-queries/112247-summing-numbers.html)

Gingit

Summing numbers
 
I have a columns with numbers. I want to add numbers to these cells. Is
there an easier way to add to that number without going to edit the cell and
inputing a +/= in the begging of the cell?

Thanks.

Aqib Rizvi

Summing numbers
 

Gingit wrote:
I have a columns with numbers. I want to add numbers to these cells. Is
there an easier way to add to that number without going to edit the cell and
inputing a +/= in the begging of the cell?

Thanks.


Gingit
The following will work

1. Write down the numbers you want to add in the next column
2. Select the cells where you have those numbers and Copy
3. Select the cells where you want to add them, and select Edit, Past
Special, Add, Ok

Regards.
Aqib Rizvi


Gingit

Summing numbers
 
Thanks but what I meant was similar way that Lotus 123 had you insert
formulas. you didn't need to add a + or = before the number.

"Aqib Rizvi" wrote:


Gingit wrote:
I have a columns with numbers. I want to add numbers to these cells. Is
there an easier way to add to that number without going to edit the cell and
inputing a +/= in the begging of the cell?

Thanks.


Gingit
The following will work

1. Write down the numbers you want to add in the next column
2. Select the cells where you have those numbers and Copy
3. Select the cells where you want to add them, and select Edit, Past
Special, Add, Ok

Regards.
Aqib Rizvi




All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com