formula for counting how many times a time is over 48hours in a month

charliew

Board Regular
Joined
Feb 20, 2018
Messages
71
Office Version
  1. 365
Platform
  1. Windows
Hi there,

I have a data set, obviously, and I need to scan through the dates to find the right months say feb. Once its found all the feb dates to then go across and count the amount of cells that have a time that's more than 48hrs. for turnaround purposes... this is how far ive got...

=countif(f2:f100,">"&A1+(48/24))

thank you!!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Provide the value/content of your cell A1 And samples of content in your range F2:F100. Providing the EXPECTED results (to us) also never hurts. Jim
 
Upvote 0
[TABLE="width: 974"]
<colgroup><col><col span="4"><col><col span="9"></colgroup><tbody>[TR]
[TD]date[/TD]
[TD]time[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]col M is a helper column[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/01/2017[/TD]
[TD="align: right"]1.7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06/01/2017[/TD]
[TD="align: right"]2.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11/01/2017[/TD]
[TD="align: right"]2.4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]problem statement[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]16/01/2017[/TD]
[TD="align: right"]1.7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]21/01/2017[/TD]
[TD="align: right"]2.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]find all times in february that are 2 hours or greater[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]26/01/2017[/TD]
[TD="align: right"]2.4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]col F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]31/01/2017[/TD]
[TD="align: right"]1.7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2017[/TD]
[TD="align: right"]2.1[/TD]
[TD][/TD]
[TD][/TD]
[TD]row 9[/TD]
[TD="align: right"]01-01-17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/02/2017[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]28-01-17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]15/02/2017[/TD]
[TD="align: right"]1.7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/02/2017[/TD]
[TD="align: right"]2.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]25/02/2017[/TD]
[TD="align: right"]2.4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/03/2017[/TD]
[TD="align: right"]1.7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/03/2017[/TD]
[TD="align: right"]2.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]12/03/2017[/TD]
[TD="align: right"]2.4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17/03/2017[/TD]
[TD="align: right"]1.7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]formula giving 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]22/03/2017[/TD]
[TD="align: right"]2.1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 8"]=SUMPRODUCT(($A$2:$A$18>=$F$9)*($A$2:$A$18<=$F$10)*($M$2:$M$18))[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
So below is a section of my data set:

A B C D E F G
[TABLE="width: 753"]
<tbody>[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD][/TD]
[TD="align: right"]16/02/2018 12:46
[/TD]
[TD="align: right"]16/02/2018 13:32
[/TD]
[TD="align: right"]16/02/2018 13:54
[/TD]
[TD]1:08:27
[/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD][/TD]
[TD="align: right"]16/02/2018 13:23
[/TD]
[TD="align: right"]16/02/2018 13:58
[/TD]
[TD="align: right"]16/02/2018 14:00
[/TD]
[TD]0:37:09
[/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD][/TD]
[TD="align: right"]19/02/2018 14:35
[/TD]
[TD="align: right"]20/02/2018 10:07
[/TD]
[TD="align: right"]20/02/2018 10:33
[/TD]
[TD]50:58:14
[/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD]20/02/2018 11:02
[/TD]
[TD="align: right"]20/02/2018 11:08
[/TD]
[TD="align: right"]20/02/2018 13:00
[/TD]
[TD="align: right"]20/02/2018 13:13
[/TD]
[TD]2:05:03
[/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD]20/02/2018 10:56
[/TD]
[TD="align: right"]20/02/2018 12:22
[/TD]
[TD="align: right"]20/02/2018 13:13
[/TD]
[TD="align: right"]20/02/2018 13:19
[/TD]
[TD]0:57:47
[/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD]20/02/2018 13:11
[/TD]
[TD="align: right"]20/02/2018 13:20
[/TD]
[TD="align: right"]20/02/2018 15:10
[/TD]
[TD="align: right"]20/02/2018 15:53
[/TD]
[TD]88:33:51
[/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Int
[/TD]
[TD]20/02/2018 14:18
[/TD]
[TD="align: right"]20/02/2018 15:45
[/TD]
[TD="align: right"]21/02/2018 08:31
[/TD]
[TD="align: right"]21/02/2018 08:34
[/TD]
[TD]1:49:12
[/TD]
[/TR]
</tbody>[/TABLE]

I need to scan F for February and then count how many times in G are > 48hrs. Its on the tip of my brain but I cant get my formula to work at all!!
 
Upvote 0
[TABLE="width: 1064"]
<colgroup><col span="2"><col><col><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext[/TD]
[TD][/TD]
[TD]16/02/2018 12:46[/TD]
[TD]16/02/2018 13:32[/TD]
[TD]16/02/2018 13:54[/TD]
[TD="align: right"]01:08:27[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD][/TD]
[TD]16/02/2018 13:23[/TD]
[TD]16/02/2018 13:58[/TD]
[TD]16/02/2018 14:00[/TD]
[TD="align: right"]00:37:09[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD][/TD]
[TD]19/02/2018 14:35[/TD]
[TD]20/02/2018 10:07[/TD]
[TD]20/02/2018 10:33[/TD]
[TD="align: right"]50:58:14[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD="align: right"]20/02/2018 11:02[/TD]
[TD]20/02/2018 11:08[/TD]
[TD]20/02/2018 13:00[/TD]
[TD]20/02/2018 13:13[/TD]
[TD="align: right"]02:05:03[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD="align: right"]20/02/2018 10:56[/TD]
[TD]20/02/2018 12:22[/TD]
[TD]20/02/2018 13:13[/TD]
[TD]20/02/2018 13:19[/TD]
[TD="align: right"]00:57:47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD="align: right"]20/02/2018 13:11[/TD]
[TD]20/02/2018 13:20[/TD]
[TD]20/02/2018 15:10[/TD]
[TD]20/02/2018 15:53[/TD]
[TD="align: right"]88:33:51[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD="align: right"]20/02/2018 14:18[/TD]
[TD]20/02/2018 15:45[/TD]
[TD]21/02/2018 08:31[/TD]
[TD]21/02/2018 08:34[/TD]
[TD="align: right"]01:49:12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]problem statement[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]for every february date in column F count how many times in column G are 48 hours or greater[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]COLUMN H is a helper column that flags the rows that satisfy the conditions[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]01/02/2018 00:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]28/02/2018 00:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48:00:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
[TABLE="width: 1064"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD][/TD]
[TD]16/02/2018 12:46
[/TD]
[TD]16/02/2018 13:32
[/TD]
[TD]16/02/2018 13:54
[/TD]
[TD="align: right"]01:08:27
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD][/TD]
[TD]16/02/2018 13:23
[/TD]
[TD]16/02/2018 13:58
[/TD]
[TD]16/02/2018 14:00
[/TD]
[TD="align: right"]00:37:09
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD][/TD]
[TD]19/02/2018 14:35
[/TD]
[TD]20/02/2018 10:07
[/TD]
[TD]20/02/2018 10:33
[/TD]
[TD="align: right"]50:58:14
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD="align: right"]20/02/2018 11:02
[/TD]
[TD]20/02/2018 11:08
[/TD]
[TD]20/02/2018 13:00
[/TD]
[TD]20/02/2018 13:13
[/TD]
[TD="align: right"]02:05:03
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD="align: right"]20/02/2018 10:56
[/TD]
[TD]20/02/2018 12:22
[/TD]
[TD]20/02/2018 13:13
[/TD]
[TD]20/02/2018 13:19
[/TD]
[TD="align: right"]00:57:47
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Ext
[/TD]
[TD="align: right"]20/02/2018 13:11
[/TD]
[TD]20/02/2018 13:20
[/TD]
[TD]20/02/2018 15:10
[/TD]
[TD]20/02/2018 15:53
[/TD]
[TD="align: right"]88:33:51
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW
[/TD]
[TD]Int
[/TD]
[TD="align: right"]20/02/2018 14:18
[/TD]
[TD]20/02/2018 15:45
[/TD]
[TD]21/02/2018 08:31
[/TD]
[TD]21/02/2018 08:34
[/TD]
[TD="align: right"]01:49:12
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]problem statement
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]for every february date in column F count how many times in column G are 48 hours or greater
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]COLUMN H is a helper column that flags the rows that satisfy the conditions
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]01/02/2018 00:00
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]28/02/2018 00:00
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48:00:00
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

thank you so much for your time on this! It has become a lot more complicated in the mean time!!

I need to scan column f for February, then column b for enquiry type and then column g for enquiry's that have taken longer than 48 hours. is that even possible? so eventually ill have a neat little table telling me how many Ext, Comp and Int took over 48 hours...
[TABLE="width: 830"]
<tbody>[TR]
[TD]TA[/TD]
[TD]Type of Enquiry (Internal, External)[/TD]
[TD]Date In[/TD]
[TD]Date Start[/TD]
[TD]Date Out[/TD]
[TD]Turnaround
(hh:mm:ss)[/TD]
[TD]Site [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD]15/12/2017 00:00[/TD]
[TD]28/12/2017 12:05[/TD]
[TD]28/12/2017 12:30[/TD]
[TD]68:00:41[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]22/12/2017 00:00[/TD]
[TD]28/12/2017 12:31[/TD]
[TD]28/12/2017 12:35[/TD]
[TD]23:05:26[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]22/12/2017 00:00[/TD]
[TD]28/12/2017 12:35[/TD]
[TD]28/12/2017 12:39[/TD]
[TD]23:09:14[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]22/12/2017 00:00[/TD]
[TD]28/12/2017 12:39[/TD]
[TD]28/12/2017 12:42[/TD]
[TD]23:12:53[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]22/12/2017 00:00[/TD]
[TD]28/12/2017 12:43[/TD]
[TD]28/12/2017 12:46[/TD]
[TD]23:16:42[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]13/12/2017 00:00[/TD]
[TD]28/12/2017 12:48[/TD]
[TD]28/12/2017 12:51[/TD]
[TD]86:21:41[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]13/12/2017 00:00[/TD]
[TD]28/12/2017 12:54[/TD]
[TD]28/12/2017 12:59[/TD]
[TD]86:29:03[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]11/12/2017 00:00[/TD]
[TD]28/12/2017 12:59[/TD]
[TD]28/12/2017 13:03[/TD]
[TD]104:33:48[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Comp[/TD]
[TD="align: right"]06/11/2017 00:00[/TD]
[TD]28/12/2017 13:17[/TD]
[TD]28/12/2017 13:22[/TD]
[TD]329:52:15[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Comp[/TD]
[TD="align: right"]13/11/2017 00:00[/TD]
[TD]28/12/2017 13:23[/TD]
[TD]28/12/2017 13:26[/TD]
[TD]284:56:05[/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col span="3"><col><col></colgroup>[/TABLE]
 
Upvote 0
[TABLE="width: 1093"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]TA[/TD]
[TD]ENQ TYPE[/TD]
[TD]DATE IN[/TD]
[TD]DATE START[/TD]
[TD]DATE OUT[/TD]
[TD]TURNAROUND (HOURS)[/TD]
[TD]HELPER1[/TD]
[TD]HELPER2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD]15/02/2018 09:00[/TD]
[TD]16/02/2018 12:46[/TD]
[TD]19/02/2018 13:32[/TD]
[TD]72.77[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]15/02/2018 09:00[/TD]
[TD]16/02/2018 13:23[/TD]
[TD]19/02/2018 13:58[/TD]
[TD]72.58[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Comp[/TD]
[TD]15/02/2018 09:00[/TD]
[TD]19/02/2018 14:35[/TD]
[TD]20/02/2018 10:07[/TD]
[TD]19.53[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD]20/02/2018 11:02[/TD]
[TD]20/02/2018 11:08[/TD]
[TD]23/02/2018 13:00[/TD]
[TD]73.87[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]20/02/2018 10:56[/TD]
[TD]20/02/2018 12:22[/TD]
[TD]20/02/2018 13:13[/TD]
[TD]0.85[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Comp[/TD]
[TD]17/02/2018 13:11[/TD]
[TD]17/02/2018 13:20[/TD]
[TD]20/02/2018 15:10[/TD]
[TD]73.83[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]20/02/2018 14:18[/TD]
[TD]20/02/2018 15:45[/TD]
[TD]21/02/2018 08:31[/TD]
[TD]16.77[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]I HAVE CHANGED SOME OFYOUR DATA FOR TEST PURPOSES[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]note col F is hours as a mathemeatical number[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]the first value (72.77) is derived from[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]=(E2-D2)*24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]start date[/TD]
[TD]01/02/2018 00:00[/TD]
[TD][/TD]
[TD="colspan: 3"]any of the 3 values to the left can be changed as desired[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]end date[/TD]
[TD]28/02/2018 00:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]longer than (days)[/TD]
[TD="align: right"]2.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01/02/2018 00:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]28/02/2018 00:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Ext[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Int[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Comp[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]formula giving 2 for Ext[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]=SUMPRODUCT(($B$2:$B$8=C25)*($G$2:$G$8=1)*($H$2:$H$8=1))[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
[TABLE="width: 1093"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]TA[/TD]
[TD]ENQ TYPE[/TD]
[TD]DATE IN[/TD]
[TD]DATE START[/TD]
[TD]DATE OUT[/TD]
[TD]TURNAROUND (HOURS)[/TD]
[TD]HELPER1[/TD]
[TD]HELPER2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD]15/02/2018 09:00[/TD]
[TD]16/02/2018 12:46[/TD]
[TD]19/02/2018 13:32[/TD]
[TD]72.77[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]15/02/2018 09:00[/TD]
[TD]16/02/2018 13:23[/TD]
[TD]19/02/2018 13:58[/TD]
[TD]72.58[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Comp[/TD]
[TD]15/02/2018 09:00[/TD]
[TD]19/02/2018 14:35[/TD]
[TD]20/02/2018 10:07[/TD]
[TD]19.53[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Ext[/TD]
[TD]20/02/2018 11:02[/TD]
[TD]20/02/2018 11:08[/TD]
[TD]23/02/2018 13:00[/TD]
[TD]73.87[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]20/02/2018 10:56[/TD]
[TD]20/02/2018 12:22[/TD]
[TD]20/02/2018 13:13[/TD]
[TD]0.85[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Comp[/TD]
[TD]17/02/2018 13:11[/TD]
[TD]17/02/2018 13:20[/TD]
[TD]20/02/2018 15:10[/TD]
[TD]73.83[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD]Int[/TD]
[TD]20/02/2018 14:18[/TD]
[TD]20/02/2018 15:45[/TD]
[TD]21/02/2018 08:31[/TD]
[TD]16.77[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]I HAVE CHANGED SOME OFYOUR DATA FOR TEST PURPOSES[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]note col F is hours as a mathemeatical number[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]the first value (72.77) is derived from[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]=(E2-D2)*24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]start date[/TD]
[TD]01/02/2018 00:00[/TD]
[TD][/TD]
[TD="colspan: 3"]any of the 3 values to the left can be changed as desired[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]end date[/TD]
[TD]28/02/2018 00:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]longer than (days)[/TD]
[TD="align: right"]2.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]% TOTAL ENQS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01/02/2018 00:00[/TD]
[TD][/TD]
[TD]EXCEEDING[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]28/02/2018 00:00[/TD]
[TD]TOTAL ENQS[/TD]
[TD]SPECIFIED TIME[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Ext[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]100.0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Int[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]33.3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Comp[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]50.0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]formula giving 2 for Ext[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]=SUMPRODUCT(($B$2:$B$8=C25)*($G$2:$G$8=1)*($H$2:$H$8=1))[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,223,898
Messages
6,175,274
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top