Drop down menus

  • Thread starter Thread starter sk1951
  • Start date Start date
S

sk1951

is there any way to use functions (lookup, count if, etc) based on the
value in a drop down menu?
 
sk1951, with what you want to count in a drop down in A1 and the range you
want to count in B1:B10

=COUNTIF(B1:B10,A1)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default value in Drop down menu and automatic selections 3
Modifying Data in Drop Down Menu 2
Auto fill Cells with text 2
Dependent drop down dynamic range formula, off sheet. 7
Vlookups not working 2
Dependent Validation 1
Nesting drop-down menus 1
Drop Down list predicated on other drop down lists 2

Back
Top