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)
.
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 () that is on the left (to vote, you need to have karma of at least 5).