Numbers User Guide for Mac
 Welcome

 Intro to Numbers
 Intro to images, charts, and other objects
 Create a spreadsheet
 Open or close spreadsheets
 Personalize templates
 Use sheets
 Undo or redo changes
 Save your spreadsheet
 Find a spreadsheet
 Delete a spreadsheet
 Print a spreadsheet
 Change the sheet background
 Touch Bar for Numbers
 Use VoiceOver to create a spreadsheet

 Use iCloud with Numbers
 Import an Excel or text file
 Export to Excel or another file format
 Reduce the spreadsheet file size
 Save a large spreadsheet as a package file
 Restore an earlier version of a spreadsheet
 Move a spreadsheet
 Lock a spreadsheet
 Passwordprotect a spreadsheet
 Create and manage custom templates
 Copyright
Functions that accept conditions and wildcards in Numbers on Mac
Some functions, such as SUM, operate on entire ranges. Other functions, such as SUMIF, operate only on the cells in the range that meet a condition. For example, to add up all the numbers in column B that are less than 5, you could use:
SUMIF(B,“<5”)
The second argument of SUMIF is called a condition because it causes the function to ignore cells that don’t meet the requirements.
There are two types of functions that take conditions:
Functions that have names ending in IF or IFS (except for the function IF, which doesn’t take a condition; it instead takes an expression that should evaluate to either TRUE or FALSE). These functions can do numeric comparisons in their conditions, such as “>5", “<=7", or “<>2". These functions also accept wildcards in specifying conditions. For example, to count the number of cells in column B that begin with the letter “a,” you could use:
COUNTIF(B,“a*”)
Functions that take conditions, such as HLOOKUP, but can’t do numeric conditions. These functions sometimes permit the use of wildcards.
Functions that allow numeric comparisons or wildcards
Function  Allows numeric comparisons  Accepts wildcards  Accepts regular expressions 

AVERAGEIF  Yes  Yes  Yes 
AVERAGEIFS  Yes  Yes  Yes 
COUNTIF  Yes  Yes  Yes 
COUNTIFS  Yes  Yes  Yes 
COUNTMATCHES  No  Yes  Yes 
HLOOKUP  No  If exact match specified  Yes 
IF  No  No  Yes 
IFS  No  No  Yes 
LOOKUP  No  Yes  Yes 
MATCH  No  If exact match specified  Yes 
MAXIFS  Yes  Yes  Yes 
MINIFS  Yes  Yes  Yes 
SEARCH  No  Yes  Yes 
SUBSTITUTE  No  Yes  Yes 
SUMIF  Yes  Yes  Yes 
SUMIFS  Yes  Yes  Yes 
TEXTAFTER  No  Yes  Yes 
TEXTBEFORE  No  Yes  Yes 
TEXTBETWEEN  No  Yes  Yes 
VLOOKUP  No  If exact match specified  Yes 
XLOOKUP  No  If exact match specified  Yes 
XMATCH  No  If exact match specified  Yes 