Counting vehicles

Hi, I would like to ask if is there any way to add values to a cell continuously?

Example:

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! 🙂

By: Junel

Leave a Reply

Your email address will not be published. Required fields are marked *