Solved

Countif in Excel

Posted on 2013-11-18
4
150 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 500 total points
ID: 39657717
Try:

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

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

757 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now