Extract Find and Concatenate

try this...
=COUNTIFS(B5:B16,B5,C5:C16,">="&C2,C5:C16,"<="&C3)

Oceans,

Attached is a modified version of your provided workbook.
In cell E1 is where you enter the start day & time
In cell E2 is where you enter the end day & time
In cell E3 is where you enter the trigger name
In cell E4 is this formula:

Please Login or Register  to view this content.

Using your provided data with Start = 6/4/2012 10:49:07 AM, End = 6/14/2012 1:58:20 AM, and Trigger Name = Account Number, the formula returns a count of 2. I verified that is correct by hand.

Oceans,

All of the formulas provided are essentially the same: they all utilize the Countifs() function.
Here is a breakdown of my formula:

In cell E1 is the start day & time
In cell E2 is the End day & time
In cell E3 is the Trigger name

The formula starts with an IF statement. The purpose is to determine if all of the criteria has been provided. The formula verifies if all of the criteria has been provided by checking these conditions:
E2<E1
COUNT(E1:E2)<2
E3=""

-If E2 (the ending day & time) is less than (earlier) than E1 (the starting day & time), then the criteria is invalid (can't have an ending time that is prior to the start time)
-The Count() function returns the number of numerical entries in a range of cells. Excel considers dates and times to be numerical entries. So if the count of numerical entries in E1 and E2 (the start and end date/times) is less than 2, which means that one or both has not been entered or the date was entered in a format Excel doesn't recognize, then the criteria is invalid (because it hasn't been fully provided)
-If E3 (the trigger name) equals blank, then the criteria is invalid (nothing has been provided for the trigger name)

So the IF statement checks those three conditions, and if any of them are true then the criteria is invalid and the formula returns a blank. If none of them are true then the IF statement proceeds to the Countifs() portion of the formula:
COUNTIFS(A2:A13,"*"&E3&"*",B2:B13,">="&E1,B2:B13,"<="&E2)

This checks column A for the trigger name using the wild card character "*". So it is essentially looking for cells in column A that contain the trigger name. Then it checks column B twice. First it checks for cells in column B that are greater than or equal to the start day & time. Next it looks for cells in column B that are less than or equal to the end day & time. Now that the countifs has checked for each criteria, it returns a count where all critiera was successfully met.

Oceans,

Nope, I typed it correctly. If any of the conditions are are true, the criteria is invalid. Each condition is a test for invalid criteria, so if any condition is true, the criteria is invalid. Only if all test are false does it mean that the criteria is valid.

are you looking for it to have 2 trigger words in the same cell? if that is the case:

Please Login or Register  to view this content.

Its just practice really. When I first joined this forum, I thought I knew Excel. Then I realized just how much I didn't know. I knew enough to start solving problems, and I'd check on threads I couldn't solve and see if I could teach myself how they got that formula working, or why they used that bit of VBA, etc. Combined with a lot of google and my own testing, its now 21 months later and my proficiency has enormously increased. So its just practice. And like they say, "Experience is the best teacher."