calculate average depending on drop-down values

[virencm]

Hi Guys

I m trying to calculate the average of 10 drop down list in a text field at the bottom of my page. the values are 1-5 and also include N/A value. if all values include a number then we just divide the sum by 10, but if there are say 2 N/A values how do i create a VBA code to automatically disregard the N/A values and only calculate the average of the number fields. is this possible?
cheers !


Viren