[Solved] Simple SUM calculation is doubling final total

Discuss the spreadsheet application

[Solved] Simple SUM calculation is doubling final total

Postby PatrickJD » Sat Jul 13, 2019 5:04 pm

Hi - I've been using this spreadsheet since Oct '17 to manage a chequing account. Very simple adding of entries week by week and the final row will tally the week's finances and equal the amount in the account.
Suddenly the SUM cell is doubling the amounts I am entering in the individual items.
In this image, you see a weekly total at the bottom. That number is copied to the top of the next column and the SUM function includes that number plus all new entries for the week.
summary.JPG
summary.JPG (12.5 KiB) Viewed 162 times


But you see the total has doubled the entry amount - The $5.00 is calculated as $10.00.

=SUM(CJ3:CJ51) - So CJ3 is the beginning balance. Cell CJ52 has the SUM calculation. Doesn't get any simpler than this.

Is there a simple setting that's been messed up? Is my file corrupt? I just can't figure this one out.

Thanks for any input.
Last edited by RusselB on Sat Jul 13, 2019 10:24 pm, edited 1 time in total.
Reason: Marked as Solved and Green check added
OPEN OFFICE 4.1.1 ON WINDOWS 10
PatrickJD
 
Posts: 3
Joined: Sat Jul 13, 2019 4:37 pm

Re: Simple SUM calculation is doubling final total

Postby RusselB » Sat Jul 13, 2019 5:11 pm

Welcome to the Forums.
Please use the same method that you used to attach the picture, but attach a copy of your spreadsheet.
Most of the information won't matter, but we need the spreadsheet to be able to properly compare what your spreadsheet actually has to what you are reporting.
Usually when something like this happens, it's because there's another SUM being included.. but without being able to see your actual spreadsheet, not a picture, there's no way for us to determine why this is happening to you.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5300
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Simple SUM calculation is doubling final total

Postby FJCC » Sat Jul 13, 2019 5:17 pm

It is very hard to tell what is going on without looking at the file itself. Can you make a copy of the file, erase everything except the two columns you show in your image and post that version?
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7230
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Simple SUM calculation is doubling final total

Postby PatrickJD » Sat Jul 13, 2019 6:06 pm

Sure no problem posting the whole file. Can't just do 2 columns because of other calculations in the file.
Last edited by PatrickJD on Sat Jul 13, 2019 6:43 pm, edited 1 time in total.
OPEN OFFICE 4.1.1 ON WINDOWS 10
PatrickJD
 
Posts: 3
Joined: Sat Jul 13, 2019 4:37 pm

Re: Simple SUM calculation is doubling final total

Postby gerard24 » Sat Jul 13, 2019 6:16 pm

Rows 48 & 49 are hidden.
Unhide and you will see why.
LibreOffice 6.2.4 on Windows 10
gerard24
Volunteer
 
Posts: 948
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Simple SUM calculation is doubling final total

Postby PatrickJD » Sat Jul 13, 2019 6:27 pm

gerard24 wrote:Rows 48 & 49 are hidden.
Unhide and you will see why.


SMH! Not sure how that happened. Thank you.
OPEN OFFICE 4.1.1 ON WINDOWS 10
PatrickJD
 
Posts: 3
Joined: Sat Jul 13, 2019 4:37 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 22 guests