§ 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#
| Formula | Description |
|---|---|
=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 |
Aggregation Footer Row#
At the bottom of every sheet, a footer row automatically shows column-level aggregates:
Number/Currencycolumns → shows SumPercentagecolumns → shows AverageTextcolumns → shows Count of non-empty cells