CONTIF 2 criterias

[StartingOut]

Hi, I have workbook that has data on my "DailyMUI's" sheet which gets sent to my "Summary" sheet. the data collected is the date which is put in B2, then on my "Summary" sheet I have data that pulls a time stamp from the "DailyMUI's" sheet. On my "Summary" sheet I need to count the number of times an entry in C:C is durring a certain time frame and also check to see if the data for the line item is equal to "Summary" date in cell B2.

So if sheet DailyMUI's colum C:C has a time <17:00 and it also has a date equal to what is in B2 on the Summary sheet then count all of the entries.

The essentialy tells me how many line items where created durring business hours and how many after hours.

=COUNTIF('DailyMUI''s'!C:C,"<17:00",'Summary'!B2)-COUNTIF('DailyMUI''s'!C:C,"<7:00",'Summary'!B2)

 

[StartingOut]

I have figured it out,

The formula I needed was

=COUNTIFS('DailyMUI''s'!C:C,"<17:00",'DailyMUI''s'!A:A,B2)-COUNTIFS('DailyMUI''s'!C:C,"<7:00",'DailyMUI''s'!A:A,B2)

 

[T. Valko]

I have figured it out,

The formula I needed was

=COUNTIFS('DailyMUI''s'!C:C,"<17:00",'DailyMUI''s'!A:A,B2)-COUNTIFS('DailyMUI''s'!C:C,"<7:00",'DailyMUI''s'!A:A,B2)

Here, try it like this...

Use cells to hold the time boundaries:

• A1 = 7:00 AM
• A2 = 5:00 PM

Then the formula becomes:

=COUNTIFS('DailyMUI''s'!C:C,">"&A1,'DailyMUI''s'!C:C,"<"&A2,'DailyMUI''s'!A:A,B2)

You do realize that you're excluding both the start time and the end time from the count? The time criteria is count if the time is AFTER 7:00 AM and BEFORE 5:00 PM.

 

[StartingOut]

I didn't see that until you pointed it out but your right thanks I will modify the string.

Thanks