Ask Your Question
1

Calc - Sum colon range - not working [closed]

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

cannedallergen gravatar image

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

Alex Kemp gravatar image

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

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
1

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

rveerd gravatar image

Move the reference to B4 out of the SUM function:

=Sheet2.B4-SUM(B5:B7)

edit flag offensive delete link more

Comments

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

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

Question Tools

1 follower

Stats

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

Seen: 3,589 times

Last updated: Aug 29 '13