Forum Discussion

Aimee_Anderson's avatar
Aimee_Anderson
Copper Contributor
Mar 06, 2020

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...
Formulas and Functions
Aimee_Anderson's avatar
Aimee_Anderson
Copper Contributor
Mar 06, 2020
@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's avatar
    Aimee_Anderson
    Copper Contributor
    Mar 06, 2020

    JKPieterse 

    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.

     

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Mar 09, 2020
      But you must already have a list of all students' tickets somewhere, don't you?
      • Aimee_Anderson's avatar
        Aimee_Anderson
        Copper Contributor
        Mar 09, 2020

        JKPieterse 

        Yes, each week every teacher sends a paper copy of their grade's tally. It is then compiled onto the digital copy where each student's ticket total is combined with the previous week for that student. This total then goes towards the house points. There are 28 grades each week. 

         

        I don't want to change the layout of the way the data is displayed. I just want to know if it is possible to create a formula or something where I can input the new week's numbers for that student and have it then add to their current total.

Resources