Im new to Calc and am doing a sheet for D&D for me and my friends. But im currently stuck on this Error / Problem! I even tried the “Auto calculate” Option and its not working
You dont need a sum function.
Divided by is done with the character “/”.
1 Like
thank you for the answer i now learned something new that i am going to use in the future. But i got a new problem wenn i try too add something to the columm G it doesnt work
or:
=B4-SUM(G2:G3)
when you really want to summarize the cellrange-like expression.
2 Likes
Thank you so much this answer worked 
… and you can learn more about how LibreOffice works, if you understand why your formula =SUM(B4-G:G) yields 73. It is due to doing an implicit intersection, which means in this case:
Formula is in cell C4 and its row 4 intersects range G:G (i.e. column G) in G4 and hence in fact your formula calculates the value of B4-G4 = 76 - 3 = 73
