| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula
=COUNTIF('mail-data'!D2:D1000, "12/01/2005and<01/01/2006") I've been trying to count a cell range that contains data on another sheet 'mail-data', where the date is bigger than 1 december 2005 and smaller than 1 january 2006. I keep getting error messages. help would be appreciated. Thanks ArchivesGirl -- archivesgirl ------------------------------------------------------------------------ archivesgirl's Profile: http://www.excelforum.com/member.php...o&userid=31827 View this thread: http://www.excelforum.com/showthread...hreadid=515511 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| countif formula | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| COUNTIF formula problems | Excel Discussion (Misc queries) | |||
| Countif formula with multiple criteria ie >30 and <60? | Excel Worksheet Functions | |||
Threaded Mode
