A range of cost centres can be specified wherever an Exact Online cost centre is available in an Excel formula. The totals are returned for each of the cost centres 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 centres 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 centres 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 centre 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 centres are structured as `YEAR-COSTCENTRE`, such as `2023-100` and `2022-100`, then using: ``` I_EOL_CCE_BAL_PDER(...;"*-100";...) ``` returns the balance for cost centre `100` across all years matching that pattern.