| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count With Date Problem
I have the following matrix and I want to count the number of rows where the
string "DOG" occurs anywhere within column A cells and the date in column B is less than today's date (assume it is 6/7/05). In this example, I would expect the result to be 2 (for matches in Row 1 and row 4. Row 1 DOG 1/1/05 Row 2 DOG, CAT 9/1/06 Row 3 CAT 1/1/05 Row 4 DOG 4/1/05 Row 5 DOG 10/1/05 I tried somthing like {=SUM(ISNUMBER((SEARCH("dog",A1:A5,1)))*TODAY()<B1 :B5}, but it doesn't work. I did enter Ctl+Shift+Enter after entering the formula. Does anyone know how I can correct this forumula? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using sumproduct to count number by date | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
| Count the occurances of a month in a range of date fields | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Threaded Mode
