Specify a range of general ledger accounts for Excel balance formula

[t6d6]

I would like to be able to specify a range of general ledger account codes for the formula I_EOL_CUT_BAL_PDER.

I can see I can add a list but separating them with a semicolon, but can I specify a range?

[forums]

See:

New Excel consolidation options for Exact Online companies and general ledger accounts

Go to Dutch version With Invantive Control, you can easily consolidate and report on general ledger accounts and multiple Exact Online companies. This can be done using hundreds of additional Excel formulas for Exact, but also via mass downloads from more than 1,000 linked Exact APIs. This consolidation and reporting takes place in Excel, but in real time with the most up-to-date financial data from multiple administrations. For EUR 59 per month, you get Exact consolidation for up to 100 admin…

A range can be specified using ‘-’ (dash):

I_EOL_BAL_PDE_CLOSE(; 2020; 1; 12; “8000-8015”)

[forums]

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.