Keynote User Guide for Mac
- Welcome
-
- Use iCloud Drive with Keynote
- Export to PowerPoint or another file format
- Reduce the presentation file size
- Save a large presentation as a package file
- Restore an earlier version of a presentation
- Move a presentation
- Delete a presentation
- Password-protect a presentation
- Lock a presentation
- Create and manage custom themes
- Copyright
Functions that accept conditions and wildcards as arguments in Keynote 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.
The table below lists all the functions that can accept conditions — either numeric comparisons, wildcards, regular expressions, or a combination of the three.
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 |