+ Reply to Thread
Results 1 to 2 of 2

Golf Standing Not Summing Correctly

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    Stone Mountain GA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Golf Standing Not Summing Correctly

    Hello,

    I'm running a golf league & it has a point system that will assign points for pars, birdies, eagles, etc. It will also assign points for 1st place, 2nd place, etc. I need to sum these points together to get the total. Sounds real simple but I can't figure out why it's not summing all the rows. And that is where I now.

    In the attached workbook on the Week 10 Standings Sheet I want for example:
    B3:O3 to sum in P3.
    But on my sheet, it will not add in B3 & I3:O3. It's only adding C3:H3.

    I know this is going to be a simple fix, but I can't figure it out.


    Shotmakers_Temp.xlsm

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Golf Standing Not Summing Correctly

    You are right - it's simple fix. :-)

    Use values (numbers) not texts in ALL your formulas. For instance in B3 you have:
    Please Login or Register  to view this content.
    while proper formula shall read
    Please Login or Register  to view this content.
    and it is the same all over your whole sheet. SUM numbers not texts, which just look like numbers
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    01-18-2013
    Location
    Stone Mountain GA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Golf Standing Not Summing Correctly

    Okay, I see.

    Thanks for your timely response. Everything working right now.

+ 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. Cells not summing up correctly
    By Swift in forum Excel General
    Replies: 5
    Last Post: 06-25-2006, 11:10 AM
  2. [SOLVED] Excel not always summing correctly
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 07:05 AM
  3. Excel not always summing correctly
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  4. [SOLVED] Excel not always summing correctly
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. Excel not always summing correctly
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2005, 01:05 PM

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