Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calls per Day
I am trying to track the number of calls per day entered onto our tracking
form. Office Patient Name Phone Number Call Date Call Outcome Springfield Nate R. (610) 555-3535 7/30/08 NWA Springfield Kate E. (610) 555-3232 8/31/08 NI Springfield Dawn C. (610) 555-3434 8/31/08 CB I was using a formula =IF(D3 = D2, 0, 1). But that was dependent on all the calls being entered in chronological order, and I wanted to see if there was a better way of doing it? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calls per Day
=COUNTIF(F3:F5,F5)
F3:F5 is the range including the dates. F5 is the cell that contains 8/31/08. The result of this function is 2. "Nate" wrote: I am trying to track the number of calls per day entered onto our tracking form. Office Patient Name Phone Number Call Date Call Outcome Springfield Nate R. (610) 555-3535 7/30/08 NWA Springfield Kate E. (610) 555-3232 8/31/08 NI Springfield Dawn C. (610) 555-3434 8/31/08 CB I was using a formula =IF(D3 = D2, 0, 1). But that was dependent on all the calls being entered in chronological order, and I wanted to see if there was a better way of doing it? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Calls closed in Given periods | Excel Worksheet Functions | |||
Excel calls for Save | Excel Discussion (Misc queries) | |||
Mobile Phone Calls | Excel Discussion (Misc queries) | |||
form that calls hidden worksheets | Excel Worksheet Functions | |||
Does anyone have a call log to track calls? | Excel Discussion (Misc queries) |