Results 1 to 7 of 7

Adding Cells Characters Function not getting constant values

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2015
    Location
    British Columbia, Canada
    MS-Off Ver
    2007
    Posts
    89

    Adding Cells Characters Function not getting constant values

    I have a listing of 12 cells with baseball positions and I'm trying to add the char value to a sum to esure only 1 position is allocated

    here is a sample code
    =CODE($E$4)+CODE($E$5)+CODE($E$6)+CODE($E$7)+CODE($E$8)+CODE($E$9)+CODE($E$10)+CODE($E$11)+CODE($E$12)

    In column E4:E12 I get 653
    In Column F4:F12 I get 638

    They both have the same positions ?

    I missing something I just can't see the answer.

    The additions are located in C35 : J39 then the macro copies 1 line (Player 11 ) to C19

    To simulate enter 9 or 10 or 11 into P1 and press Generate.

    I even built macro to activate the function ( Countif ) (Countif2)

    The code in C35 area is what is odd. It should just count the positions and the each column is the same ?

    I have enclosed my program

    I did notice that 9 positions in C35 (9 Players ) math works but 10 - 13 don't


    John

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding a constant values to certain cells in excell at a time
    By oluagbe1 in forum Excel General
    Replies: 5
    Last Post: 04-17-2017, 05:19 PM
  2. Replies: 1
    Last Post: 11-14-2016, 01:17 AM
  3. Adding characters to cells
    By L.LEE in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2013, 06:36 AM
  4. [SOLVED] Adding constant values using object variable coding
    By highlystrung in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2013, 05:18 PM
  5. Adding characters to existing column values
    By Franv in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2012, 03:44 PM
  6. Adding time values for no sequence cells with an IF function
    By Khaldon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2011, 04:00 AM
  7. Calculating Non-Constant Values in Cells
    By sesmith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2005, 12:05 PM

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