Excel · Conditional Functions

Criteria Functions Playground

SUMIF, COUNTIF, AVERAGEIF and their plural cousins let you calculate on only the rows that match your conditions. Pick a function, set criteria, and watch the matching bars light up while Excel’s exact formula and result build live.

3D Sales Data · bar = Amount

drag to orbit · green bars = rows matching your criteria

Sample Dataset · Sheet1

Row	Region	Rep	Category	Units	Amount

Criteria column (C)

Criteria value

Also: Amount ≥ 0

Live formula (as Excel evaluates it)

SUMIF

Super generates helpful tools and automates fact-checking across the internet proactively. If you enjoyed this tool, build your own with Super and share it with a friend.