I have a spreadsheet with occurences of incidents where the time of the
incident is recorded. I'm trying to count the number of times the incident
occurs between certain times (eg 7am and 11am) by using the countif function
with variations on the following formula =countif(B:B, "=07:00:00 &
<11:00:00") but it is not calculating it correctly. Can somebody help?

Try

=COUNTIF(A:A,"=07:00:00")-COUNTIF(A:A,"11:00:00")

--
Jacob


"Suzie" wrote:

I have a spreadsheet with occurences of incidents where the time of the
incident is recorded. I'm trying to count the number of times the incident
occurs between certain times (eg 7am and 11am) by using the countif function
with variations on the following formula =countif(B:B, "=07:00:00 &
<11:00:00") but it is not calculating it correctly. Can somebody help?

=SUMPRODUCT(($A$1:$A$100TIME(7,0,0))*($A$1:$A$100 <TIME(11,0,0)))
Change the cell reference A1:A100 to your desired range.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Suzie" wrote:

I have a spreadsheet with occurences of incidents where the time of the
incident is recorded. I'm trying to count the number of times the incident
occurs between certain times (eg 7am and 11am) by using the countif function
with variations on the following formula =countif(B:B, "=07:00:00 &
<11:00:00") but it is not calculating it correctly. Can somebody help?

Use cells to hold the time boundaries:

A1 = start time = 7:00 AM
A2 = end time = 11:00 AM

=COUNTIF(B:B,"="&A1)-COUNTIF(B:B,""&A2)

--
Biff
Microsoft Excel MVP


"Suzie" wrote in message
...
I have a spreadsheet with occurences of incidents where the time of the
incident is recorded. I'm trying to count the number of times the incident
occurs between certain times (eg 7am and 11am) by using the countif
function
with variations on the following formula =countif(B:B, "=07:00:00 &
<11:00:00") but it is not calculating it correctly. Can somebody help?

Thank you, all of these solutions worked!
Cheers,
Suzie

"T. Valko" wrote:

Use cells to hold the time boundaries:

A1 = start time = 7:00 AM
A2 = end time = 11:00 AM

=COUNTIF(B:B,"="&A1)-COUNTIF(B:B,""&A2)

--
Biff
Microsoft Excel MVP


"Suzie" wrote in message
...
I have a spreadsheet with occurences of incidents where the time of the
incident is recorded. I'm trying to count the number of times the incident
occurs between certain times (eg 7am and 11am) by using the countif
function
with variations on the following formula =countif(B:B, "=07:00:00 &
<11:00:00") but it is not calculating it correctly. Can somebody help?



.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Suzie" wrote in message
...
Thank you, all of these solutions worked!
Cheers,
Suzie

"T. Valko" wrote:

Use cells to hold the time boundaries:

A1 = start time = 7:00 AM
A2 = end time = 11:00 AM

=COUNTIF(B:B,"="&A1)-COUNTIF(B:B,""&A2)

--
Biff
Microsoft Excel MVP


"Suzie" wrote in message
...
I have a spreadsheet with occurences of incidents where the time of the
incident is recorded. I'm trying to count the number of times the
incident
occurs between certain times (eg 7am and 11am) by using the countif
function
with variations on the following formula =countif(B:B, "=07:00:00 &
<11:00:00") but it is not calculating it correctly. Can somebody help?



.