Home

Sum function suddenly not working

%3CLINGO-SUB%20id%3D%22lingo-sub-838926%22%20slang%3D%22en-US%22%3ESum%20function%20suddenly%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-838926%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20my%20invoice%20spreadsheets%20that%20I%20use%20month%20after%20month%20have%20all%20suddenly%20developed%20the%20same%20problem%20with%20the%20SUM%20function.%20All%20the%20cells%20are%20formatted%20to%20numbers%20except%20the%20last%20which%20is%20set%20to%20currency%2C%20the%20calculations%20options%20are%20set%20to%20automatic.%20The%20problem%20is%20that%20the%20addition%20of%20all%20the%20numbers%20is%20incorrect.%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-838926%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-839041%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20function%20suddenly%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-839041%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F404035%22%20target%3D%22_blank%22%3E%40EnglishFig%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EValue%20in%20cell%20F24%20seems%20as%20text%2C%20convert%20it%20to%20number.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130306i0C0041418B6770B7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-839112%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20function%20suddenly%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-839112%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20quick%20response.%20It's%20not%20text%20but%20it%20did%20have%20a%20.%20instead%20of%20a%20%2C%20between%20the%20whole%20numbers%20and%20the%20decimals.%20Having%20changed%20that%20the%20sum%20is%20still%20seems%20incorrect%20as%20it%20gives%20a%20different%20number%20(2803%2C02)%20from%20that%20sent%20to%20me%20by%20the%20company%20I%20have%20to%20invoice%20(2805%2C02).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
EnglishFig
New Contributor

All my invoice spreadsheets that I use month after month have all suddenly developed the same problem with the SUM function. All the cells are formatted to numbers except the last which is set to currency, the calculations options are set to automatic. The problem is that the addition of all the numbers is incorrect.

Any suggestions?

Thanks

2 Replies

Hi @EnglishFig 

 

Value in cell F24 seems as text, convert it to number.

clipboard_image_0.png

Hello @tauqeeracma 

Thanks for your quick response. It's not text but it did have a . instead of a , between the whole numbers and the decimals. Having changed that the sum is still seems incorrect as it gives a different number (2803,02) from that sent to me by the company I have to invoice (2805,02). 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies