<div>
You want to be using a COUNTIFS formula like:<br />
=COUNTIFS(C:C,&quot;&gt;=&quot; &amp;&nbsp;I3,C:C,&quot;&lt;&quot; &amp;&nbsp;J3)<br />
<br />
This formula counts times that are equal to I3, but not those equal to J3. It also counts all times between I3 and J3.<br />
<br />
If this formula is not working for you, please post a sample workbook showing three rows of data. It is likely in such a situation that the way your data is entered will affect the required formula.
</div>


You want to be using a COUNTIFS formula like:
=COUNTIFS(C:C,">=" & I3,C:C,"<" & J3)

This formula counts times that are equal to I3, but not those equal to J3. It also counts all times between I3 and J3.

If this formula is not working for you, please post a sample workbook showing three rows of data. It is likely in such a situation that the way your data is entered will affect the required formula.

<div>
Hi cansevin,<br />
<br />
try this:<br />

<pre><code id="code-20-39657725-1">=COUNTIFS(C:C,&quot;&gt;=&quot;&amp;I3,C:C,&quot;&lt;&quot;&amp;J3)</code></pre>
<br />
Joop
</div>


Hi cansevin,

try this:


=COUNTIFS(C:C,">="&I3,C:C,"<"&J3)


Joop

<div>
Hi,<br />
<br />
You would use 2 COUNTIF() statements like so:<br />
<br />
=COUNTIF(C:C,&quot;&lt;&quot;&amp;J3)-COUNT<wbr />IF(C:C,&quot;&lt;&quot;<wbr />&amp;I3)
</div>


Hi,

You would use 2 COUNTIF() statements like so:

=COUNTIF(C:C,"<"&J3)-COUNTIF(C:C,"<"&I3)

<div>
<div class="content wysiwyg-content">
In Column C I have a list of times. In cell I3 I have a begin time and Cell J3 I have an end time.<br />
<br />
I want a total count of times in column C that are in between I3 and J3. Including I3. Any idea?
</div>
</div>


In Column C I have a list of times. In cell I3 I have a begin time and Cell J3 I have an end time.

I want a total count of times in column C that are in between I3 and J3. Including I3. Any idea?

Countif in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.