Solved

Countif in Excel

Posted on 2013-11-18
4
176 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 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

828 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