Sum function

%3CLINGO-SUB%20id%3D%22lingo-sub-1863672%22%20slang%3D%22en-US%22%3ESum%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1863672%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20add%20value%20daily%20in%20fix%20column%20but%20it's%20total%20value%20will%20show%20in%20another%20column%20automatically.%3C%2FP%3E%3CP%3Efor%20example%3A%20first%20day%3A%20A1%20column%3A%20300%2C%20It's%20total%20value%20will%20be%20in%20B1%20column%20%3D300%20Ok.%3C%2FP%3E%3CP%3E2nd%20day%3A%20A1%20column%3A%20200%2C%20It's%20total%20value%20will%20be%20in%20B1%20column%20%3D500%20Ok.%3C%2FP%3E%3CP%3E3rd%20day%3A%20A1%20column%3A%20400%2C%20It's%20total%20value%20will%20be%20in%20B1%20column%20%3D900%20Ok.%3C%2FP%3E%3CP%3E%26nbsp%3BIt%20will%20be%20automatically%20not%20manually.%20There%20is%20formula%20in%20B1%20column%20that%20will%20mention%20this%20result.%3C%2FP%3E%3CP%3EBut%20how%20it%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I would like to add value daily in fix column but it's total value will show in another column automatically.

for example: first day: A1 column: 300, It's total value will be in B1 column =300 Ok.

2nd day: A1 column: 200, It's total value will be in B1 column =500 Ok.

3rd day: A1 column: 400, It's total value will be in B1 column =900 Ok.

 It will be automatically not manually. There is formula in B1 column that will mention this result.

But how it possible?

 

0 Replies