How to write an array formula (currency) that subtracts a group of cells from the larger group?

I am using this formula =SUM(A2:A13,(-SUM(-B2:B13,-C2:C13)),D2:D13,E2:E13,F2:F13,G2:G13,H2:H13) but it is not a good way to program. I feel that an array formula would be much better to accomplish this but I am new to spreadsheets and these financial functions I have not fully understood them as of yet.

You can group ranges: =SUM(A2:A13;D2:H13)-SUM(B2:C13).

image description

Tested with LibreOffice 6.4.7.2 (x64); OS: Windows 10.0.


Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below to add more information. Thanks.

If the answer helped you, you can mark the up arrow (Upvote mark) that is on the left (to vote, you need to have karma of at least 5).