CountIF

[grogmi1]

Hello,
I have a countIF formula in my spreadsheet which looks at a cell containing a phone number and then looks down a large range to see how many times that telephone number has called in. What I'd now like to do, if possible, is for the CountIF to only look at the range of data in a given time period. In Column A is a whole list of telephone numbers, Column E is a repeat of Column A (=A8 etc) this is the column I use to check the list of phone numbers and coulmn K has the time that the number called in. What I want to do is see how many times a telephone number called in between 01:00 and 02:00.

Is this possible?

 

[arthurbr]

Depending on your layout, a Pivot Table should do the job quite easily

 

[Habtest]

You can enter the formula in second row of any blank column and drag down; and consider using Pivot for overview

=COUNTIFS($K:$K,">="&"1:00",$K:$K,"<"&"2:00",$E:$E,E2)

 

[KRice]

Here is a similar idea...

MrExcel20210204.xlsx
	A										K	L	M	N
1	Tel No										Time		Tel No	123-456-789
2	123-456-789										1:03		Time Lower	1:00
3	222-333-444										1:11		Time Upper	2:00
4	333-444-555										1:17		Count	3
5	123-456-789										1:28
6	222-333-444										1:47
7	123-456-789										1:54
8	222-333-444										2:01
9	123-456-789										2:58
10	333-444-555										3:06
11	123-456-789										3:13
grogmi1

Cell Formulas
Range	Formula
N4	N4	=COUNTIFS($A$2:$A$11,$N$1,$K$2:$K$11,">="&$N$2,$K$2:$K$11,"<="&$N$3)

 

[grogmi1]

You can enter the formula in second row of any blank column and drag down; and consider using Pivot for overview

=COUNTIFS($K:$K,">="&"1:00",$K:$K,"<"&"2:00",$E:$E,E2)

Thankyou Habtest, I've made a couple of tweaks but this works brilliantly- Thanks again