?
Solved

Countif in Excel

Posted on 2013-11-18
4
Medium Priority
?
225 Views
Last Modified: 2013-11-22
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?
0
Comment
Question by:cansevin
4 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 39657717
Try:

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

Expert Comment

by:byundt
ID: 39657721
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
 
LVL 6

Expert Comment

by:Michael
ID: 39657725
Hi cansevin,

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

Open in new window


Joop
0
 
LVL 3

Expert Comment

by:uniqueinfotech
ID: 39657739
Hi,

You would use 2 COUNTIF() statements like so:

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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question