Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif using other cell values for 'range' and 'criteria'
using excel 2007
I am trying to set up a countif function that can easily be used by basic excel users. what i want to do is have a couple of cells where the users type the text they want to search for and in which column, the countif formula would be in a seperate cell and would use the user entered values as the 'range' and 'criteria' values. Basically a countif function that doesnt require the users to manipulate the formula for each new search. the data is held on sheet 1 (approx 1000 rows), the user will enter values on sheet 2. eg user types A:A and postgrad Then countif formula picks up these values and counts on sheet 1, col A for the entry 'postgrad' |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif(Range,criteria) question | Excel Worksheet Functions | |||
Countif with a Range of criteria | Excel Worksheet Functions | |||
countif, range and criteria | Excel Discussion (Misc queries) | |||
Countif with date range criteria | Excel Worksheet Functions | |||
SUM(COUNTIF(range,NOT Criteria)) | Excel Worksheet Functions |