| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get a drop down to update the range of a formula
I have created the following formula:-
=COUNTIF(Sheet1!A3:A7,$A$2) What I would like to do is create a countif formula looks in different sheets (but at the same range) based on what the users has selected in a drop down. So if the users has selected from the drop down Sheet1 the formula looks in sheet1, if the users selects Sheet2 the formula looks in Sheet2 Can you help Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Update drop-down list? | Excel Discussion (Misc queries) | |||
| Drop down list Update | Excel Discussion (Misc queries) | |||
| Drop Down--How do I copy and update cell link/input range | Excel Discussion (Misc queries) | |||
| How do I update a drop down box in Excel? | Excel Worksheet Functions | |||
| Lost Drop & Drag after update | Excel Discussion (Misc queries) | |||
Threaded Mode
