LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Create formula referencing drop down list (data validation)

I have problem creating formula referencing a drop down list, can someone help?

Example:

In the drop down list, there a

1-Below Average
2-Average
3-Good
4-Excellent

1 is given 1 point, 2 given 2 points, 3 given 3 points and 4 given 4 points.
Assume there are 3 drop down list, all drop down list has 3-Good.
So the mean should be (3+3+3)/3 = 3

How do I create a formula that will calculate the mean?

Thanks for your help.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing a data validation list Scott@CW Excel Discussion (Misc queries) 5 December 19th 06 10:55 PM
Missing Drop Down list -Data Validation abuelj1 Excel Discussion (Misc queries) 5 July 7th 06 01:10 AM
Drop down list box width - data validation Laura Excel Discussion (Misc queries) 1 March 17th 06 09:58 PM
Drop down list in Data Validation Big Rick Excel Discussion (Misc queries) 3 October 4th 05 04:49 PM
Data Validation using List (But needs unique list in drop down lis Tan New Users to Excel 1 July 8th 05 03:32 PM


All times are GMT +1. The time now is 06:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"