| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with SUMIF using a range of dates as criteria
I'm using Excel 2000. Column A has four dates, Column B has the
person's name. I want to count how many dates in column A fall between a date range. My data is below A2 = 1-Apr-99 A3 = 1-Dec-99 A4 = 1-2Dec-99 A5 = 2-Jan-00 B2 = Mary B3 = Peter B4 = Paul B5 = Susan I want to know how many entries in column A fell between the dates of April 1, 1999 and March 31, 2000, the count should be four. What would be the appropriate COUNTIF formula? Pardon the pun but I've lost count of how many variations I've tried to get my result. greatly appreciated? Any help would be Also, if some entries in column A were blank, would that affect the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif between 2 dates and specify criteria | Excel Discussion (Misc queries) | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| SUMIF with AND for range and criteria | Excel Worksheet Functions | |||
| SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions | |||
| can I use a range of dates as a criteria when using sumif? | Excel Worksheet Functions | |||
Threaded Mode
