Core formulas
=SUM(A1:A10)
=AVERAGE(A1:A10)
=COUNTIF(A:A,"Done")
=IFERROR(A1/B1,0)Data tools
=FILTER(A2:C, C2:C="Yes")
=UNIQUE(A2:A)
=SORT(A2:B,1,TRUE)Query
=QUERY(A1:C,"select A, sum(C) where B='North' group by A label sum(C) ''",1)Text helpers
=ARRAYFORMULA(A2:A & " " & B2:B)
=SPLIT(A2,",")
=TEXTJOIN(", ",TRUE,A2:A5)Dates and matching
=TODAY()
=DATEVALUE("2026-06-15")
=REGEXMATCH(A2,"pattern")
=IFNA(VLOOKUP(A2,D:E,2,FALSE),"Not found")