Hi, I would like to ask if is there any way to add values to a cell continuously?
I would like for E2 to have the values of E14 summed up.
Like, I would put 1 in E14 and then it shows in E2. And after awhile I’ll put 2 in E14 again and it would appear in E2 to be 3. I tried using macros but it’s too hard since I have 12 columns and 11 rows of this particular format. It’s hard to use since you have to run the macros again and again using a shortcut key. It would be so hard to tally like that.
Is it possible to use only formula in excel regarding this matter?
Thanks a lot! 🙂