Ask Your Question

Calc - Sum colon range - not working [closed]

asked 2013-08-29 11:01:52 +0100

cannedallergen gravatar image

updated 2015-11-07 10:55:36 +0100

Alex Kemp gravatar image

Hi I have an invoicing spreadsheet - all relevant cells are formatted as currency (Calc is version

I have a cell with a reference to a sum in another worksheet (B4) in the same workbook, and I have a short column of cells (invoices paid to date) which I want to sum and then subtract their total from the reference cell (the original quote). For some reason

=SUM(B4-($B$5:$B7)) fails

I've seen similar questions on the web from 2010, with no happy answers - if i cant solve this I'll have to go back to the Seattle solution - has anyone else had this and what was your solution?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-07 10:55:52.901148

1 Answer

Sort by » oldest newest most voted

answered 2013-08-29 11:08:36 +0100

rveerd gravatar image

Move the reference to B4 out of the SUM function:


edit flag offensive delete link more


Thanks very much rveerd, that solved my problem and worked perfectly

cannedallergen gravatar imagecannedallergen ( 2013-08-29 21:03:13 +0100 )edit

Question Tools

1 follower


Asked: 2013-08-29 11:01:52 +0100

Seen: 3,760 times

Last updated: Aug 29 '13