ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   SUM (How do i add more than one amount in a single cell) (https://www.excelbanter.com/excel-worksheet-functions/141464-sum-how-do-i-add-more-than-one-amount-single-cell.html)

jon846

SUM (How do i add more than one amount in a single cell)
 
I have a Sunday through Saturday work sheet.
I would like to know how would i add more than one amount in a single cell?


Toppers

SUM (How do i add more than one amount in a single cell)
 
Example?

=A1+B1+C1??

"jon846" wrote:

I have a Sunday through Saturday work sheet.
I would like to know how would i add more than one amount in a single cell?


jon846

SUM (How do i add more than one amount in a single cell)
 
thank you. But need to know how do i add two or three amounts in A1(a single
cell)


"Toppers" wrote:

Example?

=A1+B1+C1??

"jon846" wrote:

I have a Sunday through Saturday work sheet.
I would like to know how would i add more than one amount in a single cell?


jon846

SUM (How do i add more than one amount in a single cell)
 
thank you. But need to know how do i add two or three amounts in A1(a single
cell)



"Toppers" wrote:

Example?

=A1+B1+C1??

"jon846" wrote:

I have a Sunday through Saturday work sheet.
I would like to know how would i add more than one amount in a single cell?


Toppers

SUM (How do i add more than one amount in a single cell)
 
Please give an example of what you want.

"jon846" wrote:

thank you. But need to know how do i add two or three amounts in A1(a single
cell)



"Toppers" wrote:

Example?

=A1+B1+C1??

"jon846" wrote:

I have a Sunday through Saturday work sheet.
I would like to know how would i add more than one amount in a single cell?


Gord Dibben

SUM (How do i add more than one amount in a single cell)
 
In A1 enter =12+23+56+72 or whatever you wish.


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 11:03:02 -0700, jon846
wrote:

thank you. But need to know how do i add two or three amounts in A1(a single
cell)



"Toppers" wrote:

Example?

=A1+B1+C1??

"jon846" wrote:

I have a Sunday through Saturday work sheet.
I would like to know how would i add more than one amount in a single cell?




All times are GMT +1. The time now is 08:05 PM.

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