Why is Excel so stupid RRS feed

  • Question

  • Try this:

    1. type some numbers in some cells

    2. use the SUM function to get the total of those numbers

    3. go to another cell and type in another number

    4. go to another cell and set it equal to the cell that has the sum function plus the cell in #3.

    What do you get? "0". That's right 500 + 900 = 0 according to THE BRILLIANT EXCEL!

    Saturday, March 2, 2013 4:05 PM


All replies

  • I'd ask them over here.





    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Sunday, March 3, 2013 5:11 AM
  • By the way, when reading your question, I tried the following and it worked (below says what I wrote in the cells above):

    100 200 300 300 900 500 1400
    100 200 300 300 =SUM(A1:D1) 500 =E1+F1

    The following is my signature:

    Powershell Programmer & Advanced Lua Programmer

    Location: Switzerland

    Beside that, whenever you see a reply, you think is helpful, click "Vote As Helpful"! And whenever you see a reply being an answer to the main question of the thread, click "Mark As Answer" (if you opened the thread).

    I published the URL's for the icons in my signature.

    Please contact me, before reporting me, thank you.

    [string](0..21|%{[char][int]([int]("{0:d}" -f 0x28)+('577076797174-87661607769657424-8687168065964').substring(($_*2),2))})-replace' '

    Monday, March 4, 2013 8:54 AM