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

Question

Level 1

4 points

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

Reply

Answer 1

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

Reply

Answer 2

Sep 14, 2016 6:07 PM in response to emitch325

.

Reply

Answer 3

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:

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

Reply