actualNoteContentPart: When you create a [Tables](/help/tables)  in Amplenote, we allow a handful of calculations to be undertaken on the cells in your table. 
  
  # Specifying a range
  In lieu of specifying complex columns+rows ranges, Amplenote offers a simpler way to indicate which columns or row you want your calculation to include. Here's the formula:
  
  ```
  = operation([optional number of cells] [direction]) 
  ```
  
  For example, all of the following are valid ranges:
  = sum(5 right) add up the five cells to the right of this cell
  = mode(above) show the most commonly occurring number among the cells above this one
  = median(3 below) what is the median (middle value) of the three rows below the current?
  
  ## Transitive operations not supported in current implementation
  If the range that you specify includes a formula, that result of the formula is ignored in the calculation. While most spreadsheets allow you to aggregate formulas, we opted to skip it until we allow specifying a range of cells. 
  
  Our rationale is that it's common to want to apply multiple operations to a single data set. For example, if you have a row that is the average temperate for each month, you might want to add up the mean and the median temperature for the year. 
  
  
  
  
  
  
  If transitive cells were allowed, one would need to be able to specify that the data range for the two right-most columns should not include the column(s) immediately to their left. In order to avoid the complexity of labeling every cell, we accept this limitation for the time being.
  
  # Operations supported
  As of initial launch in late 2023, table formulas can include:
  
  ## average or mean
  (Sum of values) / (Count of values)
  
  ## max
  The greatest value in range.
  
  ## median
  The middle value in range, e.g., [1, 2, 3, 4, 500] has a median of "3." Usually a better measure than "average" when evaluating statistical sets, since it mollifies the hazards of outlier data. 
  
  If the range has an even number of values, we take the average of the middle two values. For example, a set of values [0, 4, 10, 3000] would have a median of (4+10)/2 = 7.
  
  ## min
  The lowest value in range.
  
  ## mode
  The most commonly occurring value in the range of values.
  
  ## product
  Multiply together all the values in range.
  
  ## sum
  Add up all the values in range.
  
  ## What's missing?
  It's usually pretty easy for us to add more types of formulas to our set, so if you have a suggestion, [please propose it on our voting boards](https://www.amplenote.com/help/feature_voting_roadmap_planning) . If you are a Founder subscriber, feel free to email Bill personally with your suggestion. 😅
  
  # Formatting results
  Since we seek to avoid the complexity of traditional spreadsheet apps that require a user set the "Format" of their cell, we automatically infer certain types of formatting.
  
  ## Currency
  If your input values include currency symbols like $ or €, the result of the formula will include the same denomination that your value(s) did.
processedNoteContent: ---
  title: Working with table formulas
  tags: 
  ---
  When you create a [Tables](/help/tables)
    in Amplenote, we allow a handful of calculations to be undertaken on the cells in your table. 
  Specifying a range
  In lieu of specifying complex columns+rows ranges, Amplenote offers a simpler way to indicate which columns or row you want your calculation to include. Here's the formula: = operation([optional number of cells] [direction]) 
  For example, all of the following are valid ranges:
  = sum(5 right) add up the five cells to the right of this cell
  = mode(above) show the most commonly occurring number among the cells above this one
  = median(3 below) what is the median (middle value) of the three rows below the current? 
  Transitive operations not supported in current implementation
  If the range that you specify includes a formula, that result of the formula is ignored in the calculation. While most spreadsheets allow you to aggregate formulas, we opted to skip it until we allow specifying a range of cells. Our rationale is that it's common to want to apply multiple operations to a single data set. For example, if you have a row that is the average temperate for each month, you might want to add up the mean and the median temperature for the year. If transitive cells were allowed, one would need to be able to specify that the data range for the two right-most columns should not include the column(s) immediately to their left. In order to avoid the complexity of labeling every cell, we accept this limitation for the time being. 
  Operations supported
  As of initial launch in late 2023, table formulas can include: 
  average or mean
  (Sum of values) / (Count of values) 
  max
  The greatest value in range. 
  median
  The middle value in range, e.g., [1, 2, 3, 4, 500] has a median of "3." Usually a better measure than "average" when evaluating statistical sets, since it mollifies the hazards of outlier data. If the range has an even number of values, we take the average of the middle two values. For example, a set of values [0, 4, 10, 3000] would have a median of (4+10)/2 = 7. 
  min
  The lowest value in range. 
  mode
  The most commonly occurring value in the range of values. 
  product
  Multiply together all the values in range. 
  sum
  Add up all the values in range. 
  What's missing?
  It's usually pretty easy for us to add more types of formulas to our set, so if you have a suggestion, [please propose it on our voting boards](https://www.amplenote.com)`
   . If you are a Founder subscriber, feel free to email Bill personally with your suggestion. 😅 
  Formatting results
  Since we seek to avoid the complexity of traditional spreadsheet apps that require a user set the "Format" of their cell, we automatically infer certain types of formatting. 
  Currency
  If your input values include currency symbols like $ or €, the result of the formula will include the same denomination that your value(s) did.
noteTitle: Working with table formulas