When you are using the "use header names as labels" feature (which I do not care for), some cells will get "names" based on the column and row headers while others will be the normal column&row references. A few things are necessary for the cell to get a name:
- The headers must be unique to that cell. For example, there can be only one cell in the table that has "License" as the column header and "Nett" as the row header, resulting in the name "License Nett". If there are two then no name is given to either.
- There seem to be some rules about what the headers can be. Text and dates are okay but numbers don't see to be.
- I assume there are additional reasons why a cell won't get a name but those are common ones.
If you need help with a formula, it is a lot easier to provide help if "use header names as labels" is off.