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...
@Jan Karel Pieterse Because I have 600 rows already. I want to tally the total number from each week for each row and I would like to be able to have excel do this for me automatically without me having to mentally calculate each row every week. It is very time-consuming. If I can just type in the numbers each week and have it calculate for me, it will save a lot of time.
Aimee_Anderson Wouldn't the attached work for you?
Thanks, but no. That is not what I am trying to do.
I work in a school. I have 600 students and each week I tally the 'gold tickets (an individual class reward system) they earn. There are roughly 10 weeks per term, and four terms per year. I want to be able to total the number of tickets earned by each student over the course of a term and/or the year without having to use a cell for each week for each student. The sheet would be huge and unmanageable if I did this.
I want to be able to enter the number of tickets earned each week into the same cell per student and have a formula add that number to the previous week's number.
- But you must already have a list of all students' tickets somewhere, don't you?
