| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down and cell values
I have created a worksheet with an limited array of text values in the cells
and set up a sequence of COUNTIF formula in an adjoining part of the sheet to count the occurrences of the particular text values which works well. However, when I change the text input cells to dropdowns sourced from a list/range in another part of the sheet the COUNTIF formulae cease to work and merely give me a value of zero. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Values from 3 separate drop-down lists entered into single cell | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| How to change drop down values based on another cell value? | Excel Discussion (Misc queries) | |||
| drop down values based on the another drop down | New Users to Excel | |||
| Refreshing drop down cell values... | Excel Worksheet Functions | |||
Threaded Mode
