A range of cost units can be specified wherever an Exact Online cost unit is available in an Excel formula. The totals are returned for each of the cost units in the range. The range can be specified using the following rules: - Empty: no filtering is applied. - Exact match, for example `A001`: only `A001` is included. - Wildcard `*` for any sequence of characters, for example `A*`: all values starting with `A` are included. - Wildcard `_` for a single character, for example `A__1`: all values starting with `A`, followed by any two characters, and ending with `1` are included. - Range using `-`, for example `A020-A040`: all cost units that fall alphabetically between the lower and upper bound are included, including both boundaries. - Combination of explicit values using `,`, for example `A001,A003,A012`: only these listed values are included. - Combination of patterns and values, for example `A__1,A__3,A012`: all values matching the two patterns, plus `A012`, are included. This makes it possible to consolidate balances across multiple cost units in a single formula, while still working in real time on the most current Exact Online financial data. One important limitation is that these wildcard ranges and combinations apply to the cost unit selection itself, but not to multiple administrations or other selection criteria. When consolidating across multiple Exact Online companies, each company still needs to be included separately in the Excel formula and then summed. ## Examples If cost units are structured as `YEAR-COSTUNIT`, such as `2023-100` and `2022-100`, then using: ``` I_EOL_CUT_BAL_PDER(...;"*-100";...) ``` returns the balance for cost unit `100` across all years matching that pattern.