SUMIF, COUNTIF & AVERAGEIF

Implementation-backed

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

What this guide covers

Criteria matching

SUMIF

COUNTIF and AVERAGEIF

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

Criteria matching

The criteria runtime recognizes comparison prefixes such as >, <, >=, <=, =, <> and != before comparing range values.

02

SUMIF

SUMIF requires a criteria range and can use a separate sum range. Matching rows contribute numeric values to the total.

03

COUNTIF and AVERAGEIF

COUNTIF counts matching range values. AVERAGEIF averages numeric values corresponding to matching criteria rows.

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.

60/100

References, Ranges & Operators

Use A1 references, rectangular ranges and VauSheet's supported arithmetic, text and comparison operators.

68/100

Logical Functions

Build conditional formulas with IF, AND, OR and NOT.