| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count if range contains match to another cell
I have an array of data on 1 sheet that contains (among other things) a
straightforward date column and also a column in which some of the cells contain the word "New". I would like to count the rows that have both the word "New", and also a date which falls within the month found in a cell on another sheet. But, the date on the other sheet is not in date format and can't be, because it has to be the 3-letter abbreviation of the month in all caps (i.e. FEB) in order for the formulas on that sheet to work. Yikes! Thank you.... Ross |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
| How to count a range of values in a single cell? | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Threaded Mode
