emitch325

Q: is there a sort of "tally" method or formula so you don't need to add the new numbers you input yourself?

I'm making a numbers spreadsheet for my mother-in-laws retail business. I have everything set up fine, but she wanted to know if there was a sort of "tally" way to add the new numbers she has to input every day, instead of having to add in her head. For example she sold 37 items of a certain style one day and the next day she sold 19..Is there a way to just add 19, to the already 37 making it add to 56 without her having to do the math herself? Thanks! (about 15 different cells for each style item she sells)

MacBook

Posted on Sep 14, 2016 4:36 PM

Close

Q: is there a sort of "tally" method or formula so you don't need to add the new numbers you input yourself?

  • All replies
  • Helpful answers

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 14, 2016 6:07 PM in response to emitch325
    Level 6 (19,282 points)
    iWork
    Sep 14, 2016 6:07 PM in response to emitch325

    assuming you mean in a particular cell she has to update the value of the cell by adding a new number once later information becomes available then I suggest this method.

     

    Currently you enter a singe value by selecting a cell, then typing the number...

    37

     

    then she needs to add 19.  Well, enter a formula instead... like this:

    =37

     

    then later, double click the cell, and change it to(position the cursor after the "37", he type "+19"):

    =37+19

     

     

    then, if you need to change it again, double click the cell and add the next value like this(position the cursor after the "19", he type "+12"):

    =37+19+12

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 14, 2016 6:07 PM in response to emitch325
    Level 6 (19,282 points)
    iWork
    Sep 14, 2016 6:07 PM in response to emitch325

    .

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 14, 2016 6:12 PM in response to Wayne Contello
    Level 6 (19,282 points)
    iWork
    Sep 14, 2016 6:12 PM in response to Wayne Contello

    Another way is to all her to enter a sequence of values that get added up (or summed) into a single total... like this:

    Screen Shot 2016-09-14 at 8.10.15 PM.png

    B2=SUM(C2:H2)

     

    this is shorthand for... select cell B2, then type (or copy and paste from here) the formula:

    =SUM(C2:H2)

     

    select cell C2, copy

    select cell C2 thru the end of column C (or as needed), paste

     

    now enter value in column C thru H