Using SuperSheetsFormulas & calculations
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
| 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 \u2192 shows SumPercentagecolumns \u2192 shows AverageTextcolumns \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.