+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Excel fomula not evaluating correctly in Technical; I've got a spreadsheet here with a simple set of calculations. Basically each column is summed, then that row is ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,623
    Thank Post
    514
    Thanked 2,442 Times in 1,890 Posts
    Blog Entries
    24
    Rep Power
    831

    Excel fomula not evaluating correctly

    I've got a spreadsheet here with a simple set of calculations. Basically each column is summed, then that row is summed at the end.

    The columns are summing correctly, but the total at the end just returns 0 all the time.

    We've checked that the cells are formatted as numbers/general, we've checked calculation is on auto. If I go into edit the formula and click the 'Calculate Now' button, it calculates correctly, and overwrites the formula with the result.

    What on earth is going on?

  2. #2

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,689
    Thank Post
    334
    Thanked 515 Times in 483 Posts
    Rep Power
    179
    Any chance of uploading file? (To show/test issue I mean). Whether it's real data or fake, just nice to be able to see it

    Steve

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 13
    Last Post: 20th February 2008, 04:29 PM
  2. [CLOSED] Bug/Error: Signature not displaying correctly
    By kearton in forum EduGeek.net Site Problems
    Replies: 2
    Last Post: 9th January 2008, 09:20 AM
  3. Replies: 6
    Last Post: 19th October 2007, 02:48 PM
  4. Replies: 2
    Last Post: 1st May 2007, 09:17 AM
  5. Replies: 9
    Last Post: 18th December 2006, 10:07 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •