SUM() =SUM(B2:B10) : Add numeric range

AVERAGE() =AVERAGE(C2:C10) : Mean of numbers

COUNT() =COUNT(A2:A10) : Count numeric cells

COUNTA() =COUNTA(A2:A10) : Count nonblank cells

COUNTBLANK() =COUNTBLANK(A2:A10) : Number of blank cells

MAX() =MAX(D2:D10) : Largest value

MIN() =MIN(D2:D10) : Smallest value

LARGE() =LARGE(D2:D10,3) : Nth largest value

SMALL() =SMALL(D2:D10,2) : Nth smallest value

SUBTOTAL() =SUBTOTAL(109,E2:E10) : Aggregate visible rows (109=SUM)

AGGREGATE() =AGGREGATE(14,6,F2:F10) : Flexible aggregate with options

SUMPRODUCT() =SUMPRODUCT(B2:B10,C2:C10) : Array product-sum (weighted totals)

SUMIF() =SUMIF(A2:A10,"East",B2:B10) : Conditional sum single criterion

SUMIFS() =SUMIFS(B2:B10,A2:A10,"East",C2:C10,">100") : Conditional sum multiple criteria

COUNTIF() =COUNTIF(A2:A10,"<>"&"") : Count matching single condition

COUNTIFS() =COUNTIFS(A2:A10,"East",C2:C10,">100") : Count with multiple conditions

AVERAGEIF() =AVERAGEIF(A2:A10,"East",B2:B10) : Average with single condition

AVERAGEIFS() =AVERAGEIFS(B2:B10,A2:A10,"East",C2:C10,">100") : Average multiple conditions