SUMIF
Add up numbers — but only the rows that match a condition.
BeginnerSmall, 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.
Topics on math, physics, and trading indicators will move to their own subdomains as they grow.
Add up numbers — but only the rows that match a condition.
BeginnerFind a value in a table and return data from the same row.
BeginnerThe modern successor to VLOOKUP. Exact match by default; looks either way.
BeginnerTwo functions that compose into the most flexible lookup pattern.
Coming soonSUMIF with multiple conditions. Different argument order — watch out.
BeginnerThe simplest decision maker — return one value if TRUE, another if FALSE.
BeginnerCount how many cells in a range meet a single condition.
Beginner