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
Bookmarks