Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count If combined functions
Excel 2003. I have a call log with the date call was received in a range
named "Date_Message_Left" fomatted as mm/dd/yyyy, and the Region number in a range called "Region". The region values are only 1, 2, 3, 4, or 5. I want a summary of calls to each region that were received in a given week. So if the region number is 1 and the date is between March 22, 2008 and March 29, 2008, then count it. Some cells in both ranges will be blank until new call is logged. I hope this is enough information. Trying to keep it short but still provide enough info. -- Betty H Salem, OR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF and lookup functions combined? | Excel Worksheet Functions | |||
IF and lookup functions combined? | Excel Worksheet Functions | |||
Vlookup + Address functions combined | Excel Worksheet Functions | |||
ISNA(MATCH...) and IF functions - can they be combined? | Excel Worksheet Functions | |||
combined two countif functions | Excel Discussion (Misc queries) |