# Countif in Excel

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?
###### Who is Participating?

x

Commented:
Try:

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

Commented:
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.
0

Hi cansevin,

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

Joop
0

Commented:
Hi,

You would use 2 COUNTIF() statements like so:

=COUNTIF(C:C,"<"&J3)-COUNTIF(C:C,"<"&I3)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.