Published on
Apple Numbers uses separate tables that can be arranged on a sheet. A reference can therefore include a table and column name. When moving from Microsoft Excel, understand that structure before transferring formulas. Our common task remains adding the open amounts for the North team.
| Team | Amount in EUR | Status |
|---|---|---|
| North | 120 | Open |
| South | 80 | Open |
| North | 30 | Closed |
| North | 50 | Open |
Name the example table Records, with its first row holding the column headings. The expected total is 170 EUR. With English function names and comma separators, the conditional sum can be expressed as:
=SUMIFS(Records::Amount,Records::Team,"North",Records::Status,"Open")Double colons separate the table name from its reference; these are not the square brackets used by structured references in Microsoft Excel. Select table and column names in the formula editor. Check language, separators and the treatment of header and footer rows in the actual version. Apple on cell and table references, Apple's function reference.
The current function help documents LET and LAMBDA. That does not make their behaviour identical to Microsoft Excel. Apple specifically describes LAMBDA.APPLY for testing a LAMBDA and restricts its definition to the cell where it is defined. An imported named function can therefore be organised differently from the original workbook. Apple on LET, Apple on LAMBDA.
Our small calculation does not need that complexity yet. An understandable conditional sum and an independent check come first. When reusable functions are introduced, review where their definitions apply and how changes affect each use.
After export and reopening in Microsoft Excel, first check the 170 EUR total. Then append an open North record worth 20 EUR and expect 190 EUR. Confirm that the new row belongs to the intended table and is included by the formula. Appearance, table structure and calculation behaviour are separate acceptance checks.
This assessment uses vendor documentation and independently calculated expected results. It does not claim a native run in Apple Numbers. The other comparisons cover Google Sheets, LibreOffice Calc and PlanMaker.
