| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count the number of rows where more than one column meets set crit
I want to find out the number of rows where the more than one column meets
criteria set in another cell. Eg: Column A is Name Column B is Date I want to find out the number of times "John" appears in column A and "14/07/06" appears in column B. If possible i'd like to reference the search criteria through another cell. My limited understanding makes me think I need a COUNTAND function but it doesn't exist. Thanks in advance for any help. Regards Barrie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Threaded Mode
