Skip to content

§ 3.4Using SuperSheets

Formulas & Calculations

SuperSheets supports an Excel-compatible formula engine. Type = in any cell to start a formula. The formula bar at the top of the editor shows and edits the raw formula while the cell displays the computed result. Cell references use column letters and row numbers (e.g. B3). Ranges are written as A1:A10.

Supported Functions#

FormulaDescription
=SUM(A1:A10)Add a range of values
=AVERAGE(B1:B5)Mean of a range
=COUNT(C1:C20)Count non-empty cells
=MIN(D1:D8)Smallest value in range
=MAX(E1:E8)Largest value in range
=IF(A1>100,"High","Low")Conditional logic
=CONCAT(A1," ",B1)Join text values
=ROUND(A1,2)Round to decimal places

At the bottom of every sheet, a footer row automatically shows column-level aggregates:

  • Number / Currency columns → shows Sum
  • Percentage columns → shows Average
  • Text columns → shows Count of non-empty cells