Tripleseas
Board Regular
- Joined
- Jul 12, 2022
- Messages
- 87
- Office Version
- 2013
- Platform
- Windows
Hello,
I have the F9 cell that calculate the cumulations of data. so whenever i add a new data i want the F9 cell to update
however, is there a way to do this without creating another cell. when i put the formula on F9 i get an error
thank you
I have the F9 cell that calculate the cumulations of data. so whenever i add a new data i want the F9 cell to update
however, is there a way to do this without creating another cell. when i put the formula on F9 i get an error
thank you
Classeur1 | |||||||
---|---|---|---|---|---|---|---|
E | F | G | H | I | |||
5 | New DATA | 20 | |||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | CUMUL | 100 | 120 | ||||
10 | formula in this cell without adding another cell | ||||||
11 | |||||||
Feuil1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G9 | G9 | =F9+F5 |