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)

 

[T. Valko]

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)

If you want to count where the time is <17:00 then why in your formula do you also have <7:00 ?

 

[StartingOut]

sorry I wasn;t clear.

My DailyMUI sheet has the date and the time stamp in each row, I need to count how may rows have a time stamp for each date (day of the month) the date is in colum A and the time stamp is colum C.

I quess the answer to your question is "I don't know" which why my formula isn't working

 

[llywelyn]

HI. It looks to me asthough you have too many things in your countif. Try
=COUNTIF('DailyMUI''s'!C:C,"<17:00")-COUNTIF('DailyMUI''s'!C:C,"<7:00")
You can not have those extra bits in. I asume you are tring to see how many ther are between 07:00 and 17:00. Im not sure what you are trying to do with the bit in cell B2.

Dan

 

[llywelyn]

Sorry, I just realised that you want to check the date too. In this case you need to do a countifs wich should work as you have done the original formula with just an "S" added.

 

[T. Valko]

sorry I wasn;t clear.

My DailyMUI sheet has the date and the time stamp in each row, I need to count how may rows have a time stamp for each date (day of the month) the date is in colum A and the time stamp is colum C.

I quess the answer to your question is "I don't know" which why my formula isn't working

Sorry, I'm still confused!

OK, you have dates in column A and times in column C.

What exactly do you want to count?

 

[llywelyn]

Sorry, I'm not actualy being much help. It might be easiest if you split the date and time out into two seperate colums. Then do your countifs on them as seperat colums.

 

[StartingOut]

Hi, I appriciate all the help, and I amy sorry nut its me that isn't clear enough so let me try again.

MY DailyMUI sheet has several columbs of data, Date, start Time, end Time and so on. I have a Summary sheet that collect the date in columb A from my DailyMUI sheet and places it in my Summar sheet in columb B starting in row 2.

Now on my Summary sheet in columb E I need a running total of the number of rows that have a time stamp between 7AM and 7PM as found in colum B in the DailyMUI sheet then the formula needs to check colum B row 2 on my Summary sheet to see if the date matches the date stamp in columb a of my DailyMUI sheet.

 

[T. Valko]

Hi, I appriciate all the help, and I amy sorry nut its me that isn't clear enough so let me try again.

MY DailyMUI sheet has several columbs of data, Date, start Time, end Time and so on. I have a Summary sheet that collect the date in columb A from my DailyMUI sheet and places it in my Summar sheet in columb B starting in row 2.

Now on my Summary sheet in columb E I need a running total of the number of rows that have a time stamp between 7AM and 7PM as found in colum B in the DailyMUI sheet then the formula needs to check colum B row 2 on my Summary sheet to see if the date matches the date stamp in columb a of my DailyMUI sheet.

What version of Excel are you using?

 

[StartingOut]

I am using 2007