ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Drop dwn menu. Formula to count selection frm menu in anoth cell? (https://www.excelbanter.com/excel-worksheet-functions/189483-drop-dwn-menu-formula-count-selection-frm-menu-anoth-cell.html)

ggoldber

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


ryguy7272

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



All times are GMT +1. The time now is 04:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com