| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF: 2 criteria: Date Range Column & Text Column
=SUMPRODUCT(--(C2:C200="text"),--(F2:F200=--"2005-01-01"),--(F2:F200<=--"20
05-01-31")) -- HTH RP (remove nothere from the email address if mailing direct) "MAC" wrote in message ... Col C = Text and Col F = dates I would like to count the # of times a value occurs in Col C based on a date range in Col F. Does anybody have an answer to this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Value between 2 dates | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| I need a formula to find rows within a date range in one column? | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
Threaded Mode
