|
|
|
|
#1
08-06-2010, 06:10 PM
|
|||
|
|||
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 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Using Conditions to Add Values
|
EclipticalD | Excel | 1 | 07-08-2010 09:50 PM |
| Can't calculate formulas | Cpat | Excel | 2 | 06-09-2010 02:07 PM |
|
Using Field Codes to Calculate 5 years from a Date
|
vandy | Word | 1 | 09-23-2009 11:32 AM |
| Word - Calculate and paste values from Excel sheet | Augf87 | Word | 1 | 07-06-2009 10:26 AM |
|
How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Windows XP 
Office 2003
Hybrid Mode