Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Drop dwn menu. Formula to count selection frm menu in anoth cell?

Want to count a selection from a drop down menu every time it is selected and
have the sum of the "hits" appear in another cell. Cannot figure out
formula. Help would be appreciated.

Thanks

Jerry

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Drop dwn menu. Formula to count selection frm menu in anoth cell?

See if this helps you:
http://www.contextures.com/xlDataVal13.html

or this:
http://www.contextures.com/xlautofilter02.html

or this:
http://www.contextures.com/xlautofilter02.html#Count


Regards,
Ryan---


--
RyGuy


"ggoldber" wrote:

Want to count a selection from a drop down menu every time it is selected and
have the sum of the "hits" appear in another cell. Cannot figure out
formula. Help would be appreciated.

Thanks

Jerry

Reply
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
filter dropdown menu so 2nd drop menu is customized menugal Excel Worksheet Functions 1 September 4th 07 05:25 PM
Cell drop menu Spitzuser Excel Worksheet Functions 1 June 22nd 06 12:36 AM
how to make a menu selection in the same cell? Eve Excel Discussion (Misc queries) 1 March 29th 06 08:29 PM
Hiding a cell's drop-down menu, dependent on a tick-box selection... mintos Excel Discussion (Misc queries) 1 February 9th 06 02:13 PM
need to populate several cells based on drop down menu selection TerriF Excel Discussion (Misc queries) 1 May 18th 05 10:27 PM


All times are GMT +1. The time now is 10:34 AM.

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

About Us

"It's about Microsoft Excel"