Forum Discussion
Aimee_Anderson
Mar 06, 2020Copper Contributor
Excel formula help
Hi, I am trying to find a formula that will allow me to tally into one cell. Ideally, I would like to be able to add any new number into a cell each week and have that number added to the number ad...
JKPieterse
Mar 06, 2020Silver Contributor
What is wrong with just entering the weekly numbers beneath each other? It isn't as if there aren't enough rows available in Excel 🙂 If you convert the range of numbers to a table (Format as table option) it is very easy to create a sum formula that always points to all of the numbers.