Countif between 6 am & 2 pm

wickedchew wickedchew is offline

Senior Member

Location: Philippines

Posts: 161

Quote:

Originally Posted by Traci A

I need to count the number of times on several dates (on the same row as the time) there are between 6 am & 2 pm; 2pm to 10 pm; 10 pm to 6 am.
E.G. Row 111 column B-7-31-10 column c-11:55 pm would count as 1.
I am counting the number of assessments done per shift.

Try:

=IF(AND(Assessment time taken=6am, Assessment time taken<=2pm),1,0)

Then count all cells that have values of 1.

__________________
Asobi Wa Owari Da

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Countif - HELP ME!!!	Marcelo Rodrigues	Excel Discussion (Misc queries)	2	April 9th 08 12:13 PM
How do I use a countif function according to two other countif fu.	Kirsty	Excel Worksheet Functions	2	February 20th 06 11:44 AM
edit this =COUNTIF(A1:F16,"1-2")+COUNTIF(A1:F16,"2-1")	sctroy	Excel Discussion (Misc queries)	2	September 25th 05 04:13 AM
COUNTIF or not to COUNTIF on a range in another sheet	Ellie	Excel Worksheet Functions	4	September 15th 05 10:06 PM
COUNTIF in one colum then COUNTIF in another...???	JonnieP	Excel Worksheet Functions	3	February 22nd 05 02:55 PM

All times are GMT +1. The time now is 09:51 PM.

Menu

About Us