The mali-airports xls template shows the formula as
_$[COUNTIF(airport_type,"smallairport")] which is misguiding, since users cannot tell that _airporttype is a named range, created under the Data tab as shown on the image below.
We should create a guide that shows users how to create a range for the COUNTIF formula and then how to create named ranges.
XLS Reports documentation - https://help.ona.io/knowledge-base/what-is-an-xls-report/ - needs to be updated to clearly show users how to write the COUNTIF formula when preparing an XLS template.
The mali-airports xls template shows the formula as _$[COUNTIF(airport_type,"smallairport")] which is misguiding, since users cannot tell that _airporttype is a named range, created under the Data tab as shown on the image below.
We should create a guide that shows users how to create a range for the COUNTIF formula and then how to create named ranges.