Calculating a number of entries in a database based on specific conditions

Status
Not open for further replies.
A

Abbigail



I need two formulas which calculate the following in one string...

Find out how many calls were received on a weekday, between the hours of 6pm and 8am, and called regarding 'making a booking'

also

A formula that calculates how many calls were received on a weekend, between the hours of 7pm and 9am, that called regarding 'making a booking'

I've been able to create =COUNTIF(B:B,">8:00:00",B:B,"<17:59:59",C:C,"wish to make a booking")

And that calculates how many calls were received between a certain time frame and called to make a booking. I can't make one that includes the condition if the call was a weekday, or a weekend...
12/5/201019:09:4612/6/201000:12:34Query on Existing Booking12/6/201007:22:27Enquiry re: cost and schedules12/6/201010:12:12Wish to make a booking12/7/201021:07:07Query on Existing Booking12/7/201022:07:06Call for Manager or Accounts12/8/201000:48:24Wish to make a booking12/8/201007:51:21Wish to make a booking
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
C Calculating Week Number into a TextBox Outlook VBA and Custom Forms 0
J Calculating the age of an Outlook contact doesn't work Using Outlook 20
H Any c++ or java prog for calculating WhiteSpace in exchange 2010? Exchange Server Administration 4
T Increasing the number of items that appear on the Categories list Using Outlook 2
TomHuckstep Outlook 2016 Limit the number of days syncing from Google Calendar Using Outlook 1
F How to create phone number as links in notes of Contacts Using Outlook 2
I Outlook 2016 Outlook Requesting Phone Number??? Using Outlook 1
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
O How to display number of items per .pst file Using Outlook 7
S Show Total Number Of Items Not Displaying Using Outlook 9
I Identify Number of email messages opened Outlook VBA and Custom Forms 7
J Saving attachments from specific sender (phone number) to specific folder on hard drive Using Outlook 3
J How to Fix “Encounter a large number of conflict items in Exchange OST file” Using Outlook 2
S Subject add ticket number from URL query Outlook VBA and Custom Forms 2
Diane Poremsky Add a file number or keyword to the subject line of messages New Slipstick.com Articles 0
K Append subjectline based on number Using Outlook 4
B ...administrator has limited the number of items you can open simultaneously Outlook VBA and Custom Forms 7
snhnic Macro that does not overwrite but add a number Outlook VBA and Custom Forms 1
L Outlook 2007 Fix Phone Number Using Outlook 19
A Calendar List View Showing Week Number Using Outlook 1
neobite Maximum number of Exchange accounts in an Outlook profile Using Outlook 4
P Country name no longer shows in Phone number popup? Using Outlook 5
Edaniels Adding Week Number on Calender Using Outlook 2
P Outlook 2013 Phone Number Format Using Outlook 0
E Outlook VBA to print attached Pdf to a fax printer and assign fax number Using Outlook 0
D Journal problem recording correct phone number Using Outlook 7
A Assign a unique number to every message I send Using Outlook 0
S Outlook - Reset the number of day-events Using Outlook 0
Z assign unique number email Using Outlook 8
M Automatically highlight unread mail in Favorites inbox(s) (Blue number) Using Outlook 1
D Journal to show Phone Number dialled. Using Outlook 3
B Llimit the number of people accepting one of the "pick a date" meeting Using Outlook 1
O BCM 2010 - Customize a field with a consecutive number? BCM (Business Contact Manager) 1
G Change length of phone number in contacts Using Outlook 5
R printing custom number of calendar days in weekly view format Using Outlook 1
J Ho do I hide the week number on the Calendar Printing Assistant template Calendar Printing Assistant 4
S Persistent nuisance number Using Outlook 4
A Need method to rapidly correct telephone contact telephone number formatting Using Outlook 1
R NUMBER Format Using Outlook 0
M Mail in HTML format can't be sent if url or number is in the body Outlook 2010 Using Outlook 2
J Does anyone know if there is a theoretical limit to the number of personal folders permitted within Using Outlook 2
1 how to connect my cell phone number with my outlook 2007 Using Outlook 3
P Number of database on a server in DAG Exchange 2010 sp1 Exchange Server Administration 3
S 6 to 8 second delay in folders opening since installing a number of updates yesterday. Using Outlook 1
N phone number for live help Using Outlook 1
S No hyphens or parens in contact phone number Using Outlook 3
S Error updating public folder with free/busy information on virtual machine server. The error number Using Outlook 2
A How do I get Outlook 2010 to add a "+1" in front of a telephone number? Using Outlook 3
B Instant seach is indexing but the number of items to index that is shown in status stays the same. Using Outlook 3
I This message was not processed because it contains a large number of MIME bodies Using Outlook 2
Similar threads


















































Top