Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am building a call log sheet for a friend. He needs to log each phone call
he makes each month, and track numbers of call-back requests. There are 2 columns in question. Column E is the date that the phone call was originally made. Every used row will have a date in col E. Column F contains a note related to the call-back request. If there is no further action required, the cell in col F will be blank. My goal is to have a function (probably array function) to count the number of non-blank cells in col F for each month, as noted in col E of the phone call date. The analysis will appear on a separate sheet. Example source data: E F 2/1/2006 call back 5/4 2/1/2006 2/16/2006 send fax 2/27/2006 3/1/2006 3/7/2006 call back 4/1 3/8/2006 email pricelist 3/9/2006 3/14/2006 3/18/2006 call back 5/12 Example Results: Feb. 2006: 2 Mar. 2006: 3 I am currently using array function {=SUM((MONTH(Data!$E$3:$E$6000)=$A3)*(YEAR(Data!$E $3:$E$6000)=$A$2))} to simply count the number of calls made, but am stumped as far as counting non-blank cells adjacent to this column. Thank you for your assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I count items within a date range in Excel? | Excel Worksheet Functions | |||
how to check if date falls within range | Excel Worksheet Functions | |||
Date range criteria and Pivot tables (again!) | Excel Worksheet Functions | |||
Count the occurances of a month in a range of date fields | Excel Worksheet Functions | |||
count weekdays in a date range | Excel Worksheet Functions |