[Read on Dashport](https://dashport.ai/documentation/formulas-and-calculations)

Using SuperSheetsFormulas & calculations

Copy page

[

Dashport Docsv2.0](/documentation)

Getting Started

IntroductionCreating your account5-minute quick start

Connecting Data

Supported integrationsConnect a databaseColumn comments & AI contextSuperSheets as a sourceCredential securityRefresh intervals

Using SuperSheets

What is SuperSheets?Creating a sheetData entry & column typesFormulas & calculationsFormatting & selectionSort, filter & columnsRow operationsValidation & frozen panesImport & exportSharing & activity logKeyboard shortcutsUse as a data source

Asking Chat

How Chat worksWriting effective promptsExample conversationsBuilding charts via ChatLimits & best practices

Building Dashboards

Three ways to buildDrag-and-drop builderAsk Chat to buildSharing & permissions

Using SuperSheetsFormulas & calculations

Copy page

## Formulas & Calculations[](#ss-formulas)

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[](#ss-formulas-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[](#ss-formulas-footer)

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.

Previous

Data entry & column types

Next

Formatting & selection
