Forum Discussion
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...
Thank you. It's still not working. I think this is because column A has student names in it. The first column that I enter data into is column E.
Do I need to have (and I'm assuming I do) a second column for the totals to go into?
I took it you were entering the numbers into column A as your first post mentions. Change the A:A in the code to whatever your column is (for instance E:E). The code currently assumes the total is one column to the right of the one you are entering the numbers into. If that needs to be more, adjust the Offset(0, 1) accordingly.