Using SuperSheetsFormulas & calculations

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 \u2192 shows Sum
  • Percentage columns \u2192 shows Average
  • Text columns \u2192 shows Count of non-empty cells
Note
The footer row is read-only and always reflects the current filtered/visible data — it updates instantly when you apply or clear filters.