SUMIF
Add up numbers — but only the rows that match a condition.
Beginnerformulagym.com · Index
Understand any formula by playing with it.
Small, editable playgrounds for the formulas you actually use — change the inputs, watch the result recompute, keep the intuition.
Formula Gym turns each formula into a hands-on sandbox. Instead of memorising syntax, you change the arguments and watch the result resolve in real time — so when you hit a real problem, you reach for the right formula because you already know what each piece does. Today the catalogue covers spreadsheet functions (VLOOKUP, SUMIF, and more on the way). Math identities, physics equations, and trading indicators will follow on their own subdomains as the library grows.
01 · Excel & Google Sheets
Excel & Google Sheets formulas
Topics on math, physics, and trading indicators will move to their own subdomains as they grow.
VLOOKUP
Find a value in a table and return data from the same row.
BeginnerXLOOKUP
The modern successor to VLOOKUP. Exact match by default; looks either way.
BeginnerINDEX + MATCH
Two functions that compose into the most flexible lookup pattern.
Coming soonSUMIFS
SUMIF with multiple conditions. Different argument order — watch out.
BeginnerIF
The simplest decision maker — return one value if TRUE, another if FALSE.
BeginnerCOUNTIF
Count how many cells in a range meet a single condition.
Beginner