how can I create a running total in Numbers

Here’s how you can create a running total in Numbers and understand some of the formula symbols:

Creating a Running Total in Numbers

1. 
   
2. Set Up Your Table:
3. 
   
4. 
   

• 
  
• Suppose your values are in Column A.
  • 
    
• 
  
  • You want the running total to appear in Column B.
• 
  

1. 
   
2. 
   
3. 
   
4. 
   
5. Enter the First Value:
6. 
   
7. 
   

• 
  
• In B1, enter the formula:
• 
  
• =A1
• 
  
  • This sets the starting point of your running total.
• 
  

1. 
   
2. 
   
3. 
   
4. 
   
5. Build the Running Total Formula:
6. 
   
7. 
   

• 
  
• In B2, enter:
• 
  
• =B1 + A2
• 
  
  • This adds the current value in A2 to the previous total in B1.
• 
  
• Drag or copy this formula down Column B for subsequent rows.
• 
  
  • Each cell in Column B will add the new row’s value (from Column A) to the running total above.
• 
  

Understanding Symbols in Numbers Formulas

• 
  
• Colon (:)
• 
  
• 
  
• 
  
• Function: It denotes a range of cells.
  • 
    
• 
  
  • Example: A1:A10 refers to all cells from A1 through A10.
• 
  
• 
  
• 
  
• 
  
• 
  
• Dollar Sign ($)
• 
  
• 
  
• 
  
• Function: It creates an absolute reference that doesn’t change when the formula is copied to other cells.
  • 
    
• 
  
• Examples:
  • 
    
• 
  
• 
  
• $A$1 locks both the column and the row.
  • • 
      
• 
  
• $A1 locks the column A, but the row can change when copied.
  • • 
      
• 
  
  • • A$1 locks the row 1, but the column can change when copied.
• 
  
• 
  
  • 
    
• 
  
• 
  
• 
  
• 
  

These tools let you design dynamic spreadsheets in Numbers where you can easily track totals and lock references as needed. Let me know if you need more examples or further clarification!

You could use the SUM() function to keep a running total. If you had the row total in Column C, you could put the running total in Column D:

=SUM(C$2:C2)

Then use autofill for all the rows below.

":" means you are referencing a range of cells. A2:D6 means the rectangle of all cells from A2 to D6. "$" means "preserve" which is useful for autofill. So in the example above, the default behavior is to update C2 to D2, then E2, etc. as you autofill the formula down, but by specifying "C$2" for the first cell reference, you tell Numbers that you always want Row 2 no matter where the formula is.

You can check out all of the formulas and functions from Apple Support: Formulas and Functions Help - Apple Support

[94]