SUM
• =SUM(A1:A3)
• Example: 5,10,15 → 30
• Adds numbers
MAX
• =MAX(A1:A3)
• Example: 5,10,15 → 15
• Largest value
MIN
• =MIN(A1:A3)
• Example: 5,10,15 → 5
• Smallest value
AVERAGE
• =AVERAGE(A1:A3)
• Example: 5,10,15 → 10
• Average value
COUNT
• =COUNT(A1:A5)
• Counts numeric cells
COUNTA
• =COUNTA(A1:A5)
• Counts non-empty cells
COUNTBLANK
• =COUNTBLANK(A1:A5)
• Counts empty cells
COUNTIF
• =COUNTIF(A:A,">10")
• Counts with condition
COUNTIFS
• =COUNTIFS(A:A,">10",B:B,"Yes")
• Multiple conditions
SUMIF
• =SUMIF(A:A,">10",B:B)
• Conditional sum
SUMIFS
• =SUMIFS(C:C,A:A,">10",B:B,"Yes")
• Multiple condition sum
MAXIFS
• =MAXIFS(C:C,A:A,"Yes")
• Conditional max
MINIFS
• =MINIFS(C:C,A:A,"Yes")
• Conditional min
AVERAGEIF
• =AVERAGEIF(A:A,">10")
• Conditional average
AVERAGEIFS
• =AVERAGEIFS(C:C,A:A,">10",B:B,"Yes")
• Multiple conditions
SUBSTITUTE
• =SUBSTITUTE(A1,"old","new")
• Replace text
SUBTOTAL
• =SUBTOTAL(9,A1:A10)
• Ignores filtered rows
TRIM
• =TRIM(A1)
• Remove extra spaces
TODAY
• =TODAY()
• Current date
NOW
• =NOW()
• Current date & time
ROUND
• =ROUND(12.456,2)
• Round normally
ROUNDUP
• =ROUNDUP(12.451,2)
• Always round up
ROUNDDOWN
• =ROUNDDOWN(12.459,2)
• Always round down
INDEX
• =INDEX(A1:C5,2,2)
• Returns value
MATCH
• =MATCH(100,A:A,0)
• Find position
INDEX+MATCH
• =INDEX(B:B,MATCH(A1,A:A,0))
• Flexible lookup
IF
• =IF(A1>50,"Pass","Fail")
• Logical test
IFERROR
• =IFERROR(A1/B1,0)
• Hide errors
ISERROR
• =ISERROR(A1/B1)
• Checks error
AND
• =AND(A1>10,B1<5)
• All true
OR
• =OR(A1>10,B1<5)
• Any true
SWITCH
• =SWITCH(A1,1,"One",2,"Two")
• Alternative to IF
DAY
• =DAY(A1)
• Day number
MONTH
• =MONTH(A1)
• Month number
YEAR
• =YEAR(A1)
• Year number
DATEDIF
• =DATEDIF(A1,B1,"Y")
• Date difference
DATE (First of Month)
• =DATE(YEAR(A1),MONTH(A1),1)
• First day
EOMONTH (Last Date)
• =EOMONTH(A1,0)
• Last day
AGE
• =DATEDIF(DOB,TODAY(),"Y")
• Age calculation
VLOOKUP
• =VLOOKUP(A1,A:B,2,0)
• Vertical lookup
HLOOKUP
• =HLOOKUP(A1,A1:D2,2,0)
• Horizontal lookup
XLOOKUP
• =XLOOKUP(A1,A:A,B:B)
• Modern lookup
LOOKUP
• =LOOKUP(A1,A:A,B:B)
• Approx lookup
UPPER
• =UPPER(A1)
• Uppercase
LOWER
• =LOWER(A1)
• Lowercase
PROPER
• =PROPER(A1)
• Title case
LEFT
• =LEFT(A1,4)
• Left text
RIGHT
• =RIGHT(A1,2)
• Right text
MID
• =MID(A1,2,3)
• Middle text
LEN
• =LEN(A1)
• Text length
ROW
• =ROW(A1)
• Row number
COLUMN
• =COLUMN(A1)
• Column number
INDIRECT
• =INDIRECT("A1")
• Text reference
OFFSET
• =OFFSET(A1,1,1)
• Dynamic reference
FIND
• =FIND("@",A1)
• Position of text
MID+FIND
• =MID(A1,FIND("-",A1)+1,5)
• Extract text
RANK
• =RANK(A1,A:A)
• Ranking
TEXTJOIN
• =TEXTJOIN(",",TRUE,A1:A3)
• Join text
UNIQUE
• =UNIQUE(A1:A10)
• Unique values
FILTER
• =FILTER(A1:C10,B1:B10="Yes")
• Filtered data
WORKDAY
• =WORKDAY(A1,5,H:H)
• Exclude weekends/holidays
NETWORKDAYS
• =NETWORKDAYS(A1,B1,H:H)
• Working days
GROUPBY
• =GROUPBY(A:A,B:B,SUM)
• Group data
PIVOTBY
• =PIVOTBY(A:A,B:B,SUM)
• Pivot summary