Formula Comparisons
Side-by-side comparisons of related formulas — so you always pick the right tool for the job.
VLOOKUP vs INDEX/MATCH vs XLOOKUP
The three most common ways to look up data. Which should you use?
"XLOOKUP is the modern winner — but VLOOKUP is everywhere and INDEX/MATCH fills the gaps."
SUMIF vs SUMIFS vs SUMPRODUCT
Conditional summing — from simple one-condition totals to complex multi-criteria calculations.
"SUMIFS handles multiple conditions; SUMPRODUCT can do almost anything."
COUNT vs COUNTIF vs COUNTIFS
Counting cells: plain counts, conditional counts, and multi-condition counts.
"Know when to count, when to condition, and when to combine."
IF vs IFS vs SWITCH
Logical branching — from a simple yes/no to multi-branch decisions.
"Nested IFs get messy fast — IFS and SWITCH are the cleaner alternatives."
CONCATENATE vs TEXTJOIN vs CONCAT
Combining text from multiple cells. Three approaches, very different power levels.
"TEXTJOIN wins for ranges; CONCAT replaced CONCATENATE; use both for different needs."
AVERAGE vs AVERAGEIF vs AVERAGEIFS
Calculating averages: plain, conditional, and multi-condition.
"The same pattern as SUMIF — once you know one, the others follow naturally."