[Solved] SUM and INDEX/MATCH function issues

Discuss the spreadsheet application

[Solved] SUM and INDEX/MATCH function issues

Postby Tomba » Fri May 24, 2019 4:52 pm

Iv created a spreadsheet on libreoffice, adding name, numbers and rank them for me.

Now, i m having some problem.
The file is included and do have a look, look at name: Tage, he has a total of 27 point (Totalt)

Further down, with 11 + 16 + 1, using sum formula it show 28, wich is correct.. and then rank them.
Now, why doesnt totalt point show 27 point? Supose to be 28.

Iv tried to walk trough everything but im getting headache, cant figure it out.
Program bug ?
Attachments
proserien_sammenlagt_Final_justering.ods
(24.1 KiB) Downloaded 24 times
Last edited by Hagar Delest on Sun May 26, 2019 12:57 pm, edited 1 time in total.
Reason: tagged solved
Libreoffice 6.2.3.2 on Windows 10
Tomba
 
Posts: 3
Joined: Fri May 24, 2019 4:45 pm

Re: SUM and INDEX/MATCH function issues

Postby RoryOF » Fri May 24, 2019 5:03 pm

/Tools /Cell contents : AutoCalculate.

Your sheet was correct when loaded on my computer, so your autocalculate was probably off.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29052
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: SUM and INDEX/MATCH function issues

Postby Tomba » Fri May 24, 2019 5:14 pm

RoryOF wrote:/Tools /Cell contents : AutoCalculate.

Your sheet was correct when loaded on my computer, so your autocalculate was probably off.

Are you sure? Could you do a export to .pdf ..marking only table above, not below.
Libreoffice 6.2.3.2 on Windows 10
Tomba
 
Posts: 3
Joined: Fri May 24, 2019 4:45 pm

Re: SUM and INDEX/MATCH function issues

Postby Tomba » Fri May 24, 2019 5:29 pm

Never mind, appers that calc doesnt..uhm refresh or something.. i just changed a number back and forward..now it show correct.. just totalt weird. Anyho..thanks
Libreoffice 6.2.3.2 on Windows 10
Tomba
 
Posts: 3
Joined: Fri May 24, 2019 4:45 pm


Return to Calc

Who is online

Users browsing this forum: egfreeze, Villeroy and 44 guests