+ 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
    18,523
    Thank Post
    527
    Thanked 2,645 Times in 2,047 Posts
    Blog Entries
    24
    Rep Power
    924

    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,824
    Thank Post
    372
    Thanked 544 Times in 507 Posts
    Rep Power
    184
    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, 05: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, 10:20 AM
  3. Replies: 6
    Last Post: 19th October 2007, 03:48 PM
  4. Replies: 2
    Last Post: 1st May 2007, 10:17 AM
  5. Replies: 9
    Last Post: 18th December 2006, 11: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
  •