Ask Your Question
1

Calc: SUM, where each number is the result of a SUM

asked 2018-06-26 04:27:26 +0100

MJB002 gravatar image

updated 2018-06-26 13:15:50 +0100

David gravatar image

I downloaded a spreadsheet from Google Docs recently because my bad internet connection makes cloud computing impractical. I have a bunch of rows that I want to total the results of. e.g.

A1 is =SUM(1,2,3,4), B1 is =SUM(5,6,7,8) etc., and then I want to sum the results of these rows, e.g. in cell D1 =SUM(A1, A2)

What is happening is that the final cell, C1, is ignoring any value that is the result of a formula. I can't find any options that might affect this. If a cell has a value that is only a number and not the result of a formula, it is included in the final total. Only the results of formulas are being ignored.

A1, B1 etc. have to be SUM because I add to them progressively and randomly throughout the month (basically, this is a sheet to track income and spending through the month). All cells that should have numbers in them are formatted as 'number' type.

I tried using the 'formulas to values' option in Data>Calculate, but that just put a ' in front of all the numbers that I had to manually remove, and doesn't solve the problem of me needing to continually update the calculations.

edit retag flag offensive close merge delete

Comments

2

Sigh... I'd expect someone asking questions at least trying to pay attention to what they write. "A1 is ... B1 is ... D1 is =SUM(A1, A2)... in the final cell, C1..."

Mike Kaganski gravatar imageMike Kaganski ( 2018-06-26 05:04:51 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-06-26 05:08:12 +0100

Google Docs is notorious for their bad generation of downloadable documents. They often internally mark the cells with numbers/formulas as having textual data; that prevents Calc from taking those cells into account.

Try hard recalculation (Ctrl+Shift+F9), to recalculate the whole sheet.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-06-26 04:27:26 +0100

Seen: 54 times

Last updated: Jun 26 '18