lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have a column which is not fixed. I will enter numbers later in cells a10, a11, a12 etc. I want to find the total of all cells in column A, so I wrote in cell D1=sum(a:a)
My question, if I want to put this total =sum(A:A) in the first cell A1, how can I do that? Thank you very much.
I have a column which is not fixed. I will enter numbers later in cells a10, a11, a12 etc. I want to find the total of all cells in column A, so I wrote in cell D1=sum(a:a)
My question, if I want to put this total =sum(A:A) in the first cell A1, how can I do that? Thank you very much.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 1 | total | 55 | |||
2 | 2 | |||||
3 | 3 | |||||
4 | 4 | |||||
5 | 5 | |||||
6 | 6 | |||||
7 | 7 | |||||
8 | 8 | |||||
9 | 9 | |||||
10 | 10 | |||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1 | D1 | =SUM(A:A) |