+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Brackets being inserted into sum formulas

  1. #1
    Registered User
    Join Date
    04-01-2011
    Location
    Trenton NJ
    MS-Off Ver
    Excel 2007
    Posts
    1

    Brackets being inserted into sum formulas

    So this is bizarre, I have never seen anything like it, hopefully someone can help me. Excel is randomly inserting brackets into my sum formulas. My formula is below, when I go to change the date to anything, in this case 04-01-2011, it randomly inserts the brackets before it. Nothing I can do will change this. Does anyone have any ideas?


    =SUM('2007'!E5+'2008'!E5+'2009'!E5+'2010'!E5)+SUM('01-07-2011:[04-01-2011]04-01-2011'!E5)

    Thanks for your help!!!!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,434

    Re: Brackets being inserted into sum formulas

    Please post a sample workbook.

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1