If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting Dates
Column A contains a list of dates that a call was made to a Helpdesk, column
B contains a list of dates giving the Programmed Response dates for each call to the helpdesk. How do i establish those calls to the Heldesk made in April 2009 AND that also have a programmed response date of April 2009 ?? Further we have a yes/no indicator in Column C highlighting if a job was completed prior to its programmed response. Is their a formula that will count the number of calls made in April 2009, has a programmed response of April 2009 and has a yes indicator for completion prior to its programmed response? |
#2
|
|||
|
|||
Counting Dates
"Dilly" wrote in message ...
Column A contains a list of dates that a call was made to a Helpdesk, column B contains a list of dates giving the Programmed Response dates for each call to the helpdesk. How do i establish those calls to the Heldesk made in April 2009 AND that also have a programmed response date of April 2009 ?? Further we have a yes/no indicator in Column C highlighting if a job was completed prior to its programmed response. Is their a formula that will count the number of calls made in April 2009, has a programmed response of April 2009 and has a yes indicator for completion prior to its programmed response? Just extend the reply you already got. Boolean multiplication each part resolves to a True (1) or False (0) and the sums are totaled. |
#3
|
|||
|
|||
Counting Dates
It doesn't work, hence why i am asking for assistance?
I am currently using the formula below to establish the number of dates that have a date of February 2009 in column A AND column B. I am told i need this folrmula as the dates are seperated by different headings of text. However, it doesn't work =SUMPRODUCT(--(TEXT(A2:A14,"yyyy\-mm;;;")="2009-02"))*(--(TEXT(B2:B14,"yyyy\-mm;;;")="2009-02")) "David McRitchie" wrote: "Dilly" wrote in message ... Column A contains a list of dates that a call was made to a Helpdesk, column B contains a list of dates giving the Programmed Response dates for each call to the helpdesk. How do i establish those calls to the Heldesk made in April 2009 AND that also have a programmed response date of April 2009 ?? Further we have a yes/no indicator in Column C highlighting if a job was completed prior to its programmed response. Is their a formula that will count the number of calls made in April 2009, has a programmed response of April 2009 and has a yes indicator for completion prior to its programmed response? Just extend the reply you already got. Boolean multiplication each part resolves to a True (1) or False (0) and the sums are totaled. |
Thread Tools | |
Display Modes | |
|
|