I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across the same product lots of times and I don't want to have to keep adding it up in my head, then adding each one to the old number or having a column for each day.
For example, day one in the ullage diary, one vodka is spilled, so I input that. Then, I get a few days in and another two vodkas are spilled. Is there a way of inputting the second number in the same cell without having to do mental arithmetic?
This is really a very simplified example and obviously the numbers involved are super easy to add together, it's more about getting the most out of Excel and not about me not having the mental capacity to add two very small numbers together, because I do. Honest.
In my head I thought it would be good if once you select the cell if you hold alt
and whatever you type would be added to that number.