jasotastic81 I'm getting close with your scripting, this is what I need
my drop down has 9 total entries and calculates only 2 drop boxes fields
giving the grade in the total box for the two days. 1009585756040200N/AI
want the 0 to calculate as 0 so that if they get 100 one day and 0 the
next the average is 50. and the N/A if picked then it just puts what
they got for the 1st day so n/a and 100 returns 100. if both are NA then
it it should show NA. Any help would be appreciated. Dakotajessie