Wayne Burman
New Member
- Joined
- Jan 4, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi,
Is it possible to combine the number contents of a range of cells into one cell, but as a formula containing each number?
For example, if I have three adjacent cells with the following numbers in them: 3, 4 & 5.
I want to combine them into another cell, so that the new cell's contents are =3+4+5.
The new cell will show the answer of that formula, i.e. 12, but when I edit the cell, I can see the individual numbers that make up the sum.
Thanks very much,
Wayne
Is it possible to combine the number contents of a range of cells into one cell, but as a formula containing each number?
For example, if I have three adjacent cells with the following numbers in them: 3, 4 & 5.
I want to combine them into another cell, so that the new cell's contents are =3+4+5.
The new cell will show the answer of that formula, i.e. 12, but when I edit the cell, I can see the individual numbers that make up the sum.
Thanks very much,
Wayne