#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 79
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Calls closed in Given periods phocused Excel Worksheet Functions 2 January 4th 07 05:57 PM
Excel calls for Save ~Bolesław Cienki Excel Discussion (Misc queries) 2 August 25th 06 05:21 PM
Mobile Phone Calls Mr-Re Man Excel Discussion (Misc queries) 4 November 9th 05 05:02 PM
form that calls hidden worksheets Monish Excel Worksheet Functions 0 October 14th 05 05:59 AM
Does anyone have a call log to track calls? DGoldst Excel Discussion (Misc queries) 0 July 14th 05 09:57 PM


All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"