Math & Aggregation Functions

Implementation-backed

Use aggregation, rounding and numeric helper functions supported by the current VauSheet runtime.

What this guide covers

Aggregation

Numeric helpers

Rounding

Quick facts

Version1.0.1

SurfaceWeb browser

StorageCloud + local checkpoint

ThemeLight · white/orange

Documentation rule: this VauSheet section describes the current implemented product behavior. It avoids claiming full Microsoft Excel parity or live-cursor collaboration where the current build does not provide it.

01

Aggregation

SUM, AVG/AVERAGE, MIN, MAX, COUNT and COUNTA cover common totals and counts.

02

Numeric helpers

ABS, SQRT, POWER, MOD and INT support absolute value, roots, exponents, remainder and integer-floor workflows.

03

Rounding

ROUND, ROUNDUP, ROUNDDOWN, CEILING and FLOOR provide common numeric rounding and significance behavior.

Continue learning

Open the related VauSheet guides that naturally follow this topic.

62/100

Supported Formula Functions

Reference the functions implemented in the current VauSheet formula runtime instead of assuming full Microsoft Excel compatibility.

66/100

SUMIF, COUNTIF & AVERAGEIF

Calculate condition-based totals, counts and averages over VauSheet ranges.

76/100

Formula Errors & Recalculation

Troubleshoot unsupported functions, invalid ranges, division errors and recomputation behavior.