Spreadsheet functions that work in every app: 53,657 formulas counted
A count of every function in 54 real workbooks: 44 distinct functions, IF in 53 of 54 files, and the functions the templates avoid so formulas open anywhere.
The 54 workbooks Sheet Reserve launched with hold 53,657 formulas that call only 44 distinct functions. IF appears in 53 of the 54 files and in 91.7% of all formulas, followed by SUM (47 files), COUNTIF (34) and ABS (28). All 44 come from a fixed list of functions that the site's workbook specification chose because Excel, LibreOffice Calc, Google Sheets and Apple Numbers are meant to evaluate them the same way, so the formulas survive a move between those apps.
The 15 functions used in the most files, counted on 9 October 2026:
| Function | Files using it (of 54) | Total uses |
|---|---|---|
| IF | 53 | 77,108 |
| SUM | 47 | 6,309 |
| COUNTIF | 34 | 1,045 |
| ABS | 28 | 243 |
| OR | 27 | 3,352 |
| SUMIF | 24 | 929 |
| AND | 21 | 3,424 |
| INDEX | 20 | 1,308 |
| MAX | 19 | 6,500 |
| ISNUMBER | 18 | 5,664 |
| SUMPRODUCT | 18 | 4,532 |
| IFERROR | 18 | 1,772 |
| MIN | 17 | 10,145 |
| COUNT | 17 | 473 |
| COUNTA | 17 | 269 |
How were the formulas counted?
Every formula cell in all 54 launch workbooks was read, and the function names were taken from the formula text after removing quoted strings. "Total uses" counts every call, so a formula with two IF calls counts twice. "Files" counts a workbook once however often it uses the function. The formula total matches the figure the catalog tool reports for the same workbooks. The 54 are 50 templates and 4 datasets; sheets added after 9 October 2026 are not counted.
Why does almost every formula contain IF?
49,201 of the 53,657 formulas contain IF. In 48,194 of those (98.0%), one of the results is an empty string. The formula is a guard: it leaves a row blank until there is something to calculate.
Templates ship with room for more rows than the example data fills, such as up to five bidders on 80 line items or up to six debts. The guard keeps the unused rows blank instead of showing zeros or errors. Three formulas from the catalog show the pattern:
=IF(B12>0,B14/B12,"")on the Dashboard tab of the OEE calculator divides only when the denominator is above zero.=IF(ISNUMBER(F4),RANK(F4,$F$4:$F$220),"")on the Latest year tab of the GDP by country dataset ranks a country only when it has a figure.=IF(OR(B28<1,B28>B14),"",IPMT(B13,B28,B14,-B5))on the Inputs tab of the loan amortization schedule returns the interest for a period only when the period lies between 1 and the loan term.
Which functions are used the most times?
Ranked by total uses instead of files, the top of the list is IF (77,108), MIN (10,145), ROUND (9,172), MAX (6,500), SUM (6,309), ISNUMBER (5,664), SUMPRODUCT (4,532), YEAR (3,500), MONTH (3,440), AND (3,424) and OR (3,352).
A high total does not mean broad use, because one workbook can repeat a function thousands of times:
- The debt payoff planner calls MIN 8,640 times and ROUND 8,640 times.
- The prepaid and accrual schedule calls YEAR and MONTH 3,440 times each. YEAR appears in only two files and MONTH in one.
- The loan amortization schedule is the only file that uses MOD, 361 times.
Which functions do the templates avoid, and why?
The workbook specification excludes, on purpose:
- Dynamic-array functions such as FILTER, UNIQUE, SORT, XLOOKUP, LET and LAMBDA.
- Volatile functions such as TODAY, NOW, RAND, OFFSET and INDIRECT.
- TEXT, because its format codes differ between apps.
- Defined names, structured table references, array formulas and links to other workbooks.
The importer rejects a workbook that calls a function outside its list, which holds 63 functions today. Of those 63, the 54 workbooks use 44. The 19 that never appear are CHOOSE, CONCATENATE, COUNTBLANK, DATE, DAY, EXP, FV, HLOOKUP, ISBLANK, LARGE, LEFT, LEN, LN, LOWER, PV, RATE, RIGHT, TRIM and UPPER.
XLOOKUP is the one most people ask about. It is available in Excel 2021, Microsoft 365, Google Sheets and LibreOffice 24.8 and later, but not in older versions, so a template meant to open anywhere uses INDEX with MATCH (20 and 16 files) or VLOOKUP (9 files) instead. VLOOKUP or XLOOKUP covers when each is the right choice.
How long and deep are the formulas?
The median formula is 44 characters and the 90th percentile 133. The longest is 404 characters, in the fixed asset depreciation schedule, which also nests parentheses deepest, 10 levels. The most distinct functions in one file is 18, in the debt payoff planner.
Two more shares:
- 19,894 formulas (37.1%) read from another tab.
- 1,845 formulas (3.4%) call no function at all and are plain arithmetic or cell references.
Formulas that read from another tab are the ones that turn into #REF! when a tab or row is deleted, which the #REF! error page walks through.
What does this mean for a workbook that must open anywhere?
- Build around the functions in the table: IF, SUM, SUMIF and SUMIFS, COUNTIF and COUNTIFS, INDEX with MATCH, and IFERROR cover most of what the 54 workbooks do. The GDP by country dataset ranks 217 countries with 434 formulas that use only five functions: IF, ISNUMBER, INDEX, MATCH and RANK.
- Guard divisions and lookups with IF so unused rows stay blank rather than showing
#DIV/0!or#N/A. - Keep formulas short. Half of the formulas in these workbooks are 44 characters or fewer.
- Avoid volatile functions and defined names, which behave differently between apps and between versions.
- Test the file in the least capable app your recipients are likely to use before you send it.