Apple Numbers — Function Directory

Browse 8 functions with syntax, practical examples, and troubleshooting advice.

Find a function

8 functions

Browse by category

C

COUNTIFCOUNTIF in Apple Numbers: count outstanding tasks in a numbers table using practical sample data, clear expected results, …
COUNTIFSCOUNTIFS in Apple Numbers: count orders by region and size using practical sample data, clear expected results, pitfalls and …

F

FILTERFILTER in Apple Numbers: create a live view of active inventory using practical sample data, clear expected results, pitfalls …

R

REGEX.EXTRACTREGEX.EXTRACT in Apple Numbers: extract numeric case ids from free-form notes using practical sample data, clear expected …

S

SUMIFSSUMIFS in Apple Numbers: calculate revenue from one channel in one region using practical sample data, clear expected …

T

X

XLOOKUPXLOOKUP in Apple Numbers: return a price from a product code using practical sample data, clear expected results, pitfalls …