Excel, Formula =SUM not working Solved

Question

Hello,

I just summed several cells as usual, but I notice that the formula is giving me a result that is incorrect...

http://cjoint.com/?3CvlmprQIMv

See the attached file.
How can I resolve this issue?
Thank you in advance
Configuration: Windows XP / Internet Explorer 7.0

chossette9 · Accepted Answer

Hello,

the problem comes from numbers stored in text format. Where do your data come from?

To avoid this problem, convert all your cells to 'Number' format.

Best regards.
--
This guy wasn't very bright, as he was naïve.

zadare · Answer

Hello Damien, I just opened your Excel file and it's working; sum in B12 or B14 "19.50" and in C12 "68".

cbauf · Answer

Hello,

Cells B2 to B4 are in text format!

A detailed question, a precise answer! ☀️ If the question is resolved, check the desired option. Update your software! And... Thank you is not a luxury??.

speug · Answer

Hello,
I have the same problem and I have the impression that all my cells are in the format
Number?
Then I set the entire "sheet" to Number but that doesn't work either.

How can I find the problem?
Thank you very much in advance
speug

Excel, Formula =SUM not working

4 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

No sound with ps3 and hdmi

Wake up from sleep mode in windows 10.

Internet connection problem with my ipad

Free box: remote control broken

Suspicious number text message

I receive calls from unallocated numbers.

Minecraft restore the cursor and the bar.

My ps3 keeps shutting down on its own...