Home

Excel does not sum correctly

%3CLINGO-SUB%20id%3D%22lingo-sub-901135%22%20slang%3D%22en-US%22%3EExcel%20does%20not%20sum%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F136011i113A8186167D4230%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screen%20Shot%202019-10-08%20at%2010.21.44%20PM.png%22%20title%3D%22Screen%20Shot%202019-10-08%20at%2010.21.44%20PM.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Ethis%20is%20the%20sum%20Statement%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F136012i1CB4F14DC3046343%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screen%20Shot%202019-10-08%20at%2010.21.07%20PM.png%22%20title%3D%22Screen%20Shot%202019-10-08%20at%2010.21.07%20PM.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThe%20numbers%20just%20don't%20add%20up%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20top%20pic%20is%20the%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20bottom%20pic%20is%20p18%20to%20x18%20and%20the%20numbers%20don't%20add%20up%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESuggestions%20on%20how%20to%20fix%20and%20what%20is%20causing%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScary%20if%20you%20can't%20trust%20Excel%20to%20add%20correctly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-901135%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901255%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20does%20not%20sum%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901255%22%20slang%3D%22en-US%22%3EIs%20there%20a%20number%20in%20the%20hidden%20column%20F%3F%20or%20do%20you%20have%20any%20other%20hidden%20column%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901283%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20does%20not%20sum%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901283%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F171134%22%20target%3D%22_blank%22%3E%40Steve%20Urich%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20chance%20that%20Excel%20has%20performed%20the%20summation%20incorrectly%20is%20so%20small%20that%20it%20is%20hardly%20worth%20considering.%20%26nbsp%3BThe%20chance%20that%20it%20has%20performed%20an%20incorrect%20summation%20is%20far%20greater%20since%20it%20is%20the%20user%20that%20specifies%20the%20calculation%20and%20error%20is%20a%20fundamental%20part%20of%20human%20behaviour.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%20thing%20I%20would%20observe%20is%20that%20Excel%20has%20flagged%20every%20'incorrect'%20result%20with%20a%20green%20marker%20in%20the%20cell%20corner.%26nbsp%3B%20I%20cannot%20tell%20what%20is%20wrong%20from%20a%20picture%20but%20the%20error%20flag%20should%20provide%20a%20clue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-905354%22%20slang%3D%22es-ES%22%3ERe%3A%20Excel%20does%20not%20sum%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905354%22%20slang%3D%22es-ES%22%3EIn%3CBR%20%2F%3EEnglish%3A%20Good%3CBR%20%2F%3Eday%2C%20Do%3CBR%20%2F%3Ethe%20following%20test%3A%3CBR%20%2F%3E1.-%20Select%20the%20entire%20sheet%2C%202.-%20On%20the%20Home%3CBR%20%2F%3Etab%2C%20Edit%2C%20Delete%20%26gt%3B%20%26gt%3B%20select%20the%20delete%20button%20(droop%20down)%20and%20select%20delete%20formats.%20%3CBR%20%2F%3E3.-%20Check%20that%20all%20cells%20with%20numbers%20are%3CBR%20%2F%3Eright-aligned%2C%20if%20not%2C%20is%20that%20some%20cell%20is%20not%3CBR%20%2F%3Ein%20number%20format%2C%20or%20that%20the%20hidden%20decimal%20format%20that%20create%20seemingly%20false%20results.%20%3CBR%20%2F%3EThe%20man%20makes%20mistakes%2C%20the%20machines%20do%20exactly%20as%20they%20are%20asked.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-907779%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20does%20not%20sum%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907779%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BHidden%20column.%20There%20was%20a%20column%20that%20was%20hidden%20but%20still%20calculated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-907780%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20does%20not%20sum%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907780%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299247%22%20target%3D%22_blank%22%3E%40srdobrais%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Steve Urich
New Contributor

Screen Shot 2019-10-08 at 10.21.44 PM.pngthis is the sum StatementScreen Shot 2019-10-08 at 10.21.07 PM.pngThe numbers just don't add up

 

 

 

 

 

The top pic is the formula. 

The bottom pic is p18 to x18 and the numbers don't add up

 

Suggestions on how to fix and what is causing the problem.

 

Scary if you can't trust Excel to add correctly.

5 Replies
Is there a number in the hidden column F? or do you have any other hidden column?
Highlighted

@Steve Urich 

The chance that Excel has performed the summation incorrectly is so small that it is hardly worth considering.  The chance that it has performed an incorrect summation is far greater since it is the user that specifies the calculation and error is a fundamental part of human behaviour.

 

The first thing I would observe is that Excel has flagged every 'incorrect' result with a green marker in the cell corner.  I cannot tell what is wrong from a picture but the error flag should provide a clue.

En Español:
Buen día,
Haga la siguiente prueba:
1.- Seleccione toda la hoja,
2.- En la pestaña Inicio, Edición, Borrar => seleccione el botón de borrar (droop down)
y seleccione borrar formatos.
3.- Compruebe que todos las celdas con números están alineadas a la derecha,
Si no es así, es que alguna celda no está en formato de número, o que el formato oculta
decimales que crean resultados aparentemente falsos.
El hombre comete errores, las máquinas hacen exactamente lo que se les pide.

@Peter Bartholomew 

 

 Hidden column. There was a column that was hidden but still calculated.

@srdobrais 

 

Thanks for your help

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies