Thread: calculate average depending on drop-down values
View Single Post
 
Old 08-06-2010, 06:10 PM
virencm virencm is offline Windows XP Office 2003
Novice
  
Join Date: Aug 2010
Posts: 4
virencm is on a distinguished road
Default calculate average depending on drop-down values
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
Reply With Quote