[Solved] SUM and INDEX/MATCH function issues
Posted: 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 ?
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 ?