TOP 10 Excel Formulas Everyone Should Know 👇 🔵 SUM =SUM(A1:A10) — Adds values. 🔵 AVERAGE =AVERAGE(A1:A10) — Finds average. 🔵 COUNT =COUNT(A1:A10) — Counts numbers. 🔵 COUNTA =COUNTA(A1:A10) — Counts non-empty cells. 🔵 IF =IF(A1>10, "Yes", "No") — Conditional result. 🔵 MIN =MIN(A1:A10) — Smallest value. 🔵 MAX =MAX(A1:A10) — Largest value. 🔵 VLOOKUP =VLOOKUP(B1, A1:D10, 2, FALSE) — Looks up value. 🔵 & =A1 & " " & B1 — Joins text. 🔵 LEN =LEN(A1) — Counts characters.