+ Reply to Thread
Results 1 to 3 of 3

Sums function not working properly...

  1. #1
    Registered User
    Join Date
    05-13-2015
    Location
    Puerto Rico
    MS-Off Ver
    office 365 pro plus
    Posts
    1

    Sums function not working properly...

    Hello Guys:

    I have office 365 installed in my computer and I’m working on a workbook and trying to run a simple sum of some cells, for example

    =R62+X70R57+R36+R31+R26+R21+R16+R11+R6

    And it’s supposed to display the sum instantly but it doesn’t.


    please i need some light on this.

    Thanks for the help in advance.

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Sums function not working properly...

    May be a + sign is missing in between?

    =R62+X70+R57+R36+R31+R26+R21+R16+R11+R6

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Sums function not working properly...

    As pointed out, you are missing a + sign in the formula. If that isn't the error, what error message if any are you getting?

    If possible please upload a workbook showing the problem.

    Directions:

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Day Function Not Working Properly
    By clh7837 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 12:51 PM
  2. OFFSET function not working properly.
    By Terpatz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-05-2014, 09:41 PM
  3. [SOLVED] Sort function not working properly...
    By dllivermore in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2012, 05:45 PM
  4. sumproduct function not working properly
    By jls141 in forum Excel General
    Replies: 1
    Last Post: 04-27-2012, 03:15 PM
  5. vlookup function not working properly
    By carlosgdlf in forum Excel General
    Replies: 1
    Last Post: 03-05-2009, 03:24 AM

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