Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-06-2010, 06:10 PM
virencm virencm is offline calculate average depending on drop-down values Windows XP calculate average depending on drop-down values Office 2003
Novice
calculate average depending on drop-down values
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate average depending on drop-down values 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
calculate average depending on drop-down values 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
calculate average depending on drop-down values How to get cells to calculate time? jrasche2003@yahoo.com Excel 2 02-09-2007 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft