Counting Cells meeting two criteria

[Crdtk8]

I have a raw data sheet containg cells similiar to below
[TABLE="width: 895"]
<colgroup><col span="5"><col><col><col span="5"></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]CAPT[/TD]
[TD]Tail[/TD]
[TD]CBAC[/TD]
[TD]ATA[/TD]
[TD]Discrepancy[/TD]
[TD]Corrective Act[/TD]
[TD]Sta[/TD]
[TD]Flt[/TD]
[TD]MinDLY[/TD]
[TD]>30 Min[/TD]
[TD]<= 30 Mins[/TD]
[/TR]
[TR]
[TD]1/1/15[/TD]
[TD][/TD]
[TD]163[/TD]
[TD] [/TD]
[TD]3810[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[TD] [/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]1/1/15[/TD]
[TD][/TD]
[TD]171[/TD]
[TD] [/TD]
[TD]3010[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD] [/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]1/1/15[/TD]
[TD][/TD]
[TD]158[/TD]
[TD] [/TD]
[TD]2910[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]114[/TD]
[TD]114[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1/1/15[/TD]
[TD][/TD]
[TD]155[/TD]
[TD] [/TD]
[TD]2910[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]38[/TD]
[TD]38[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

What I'm trying to count is the amoount of time tail # 163 was delayed, and that delay was <= 30 Mins. I've played around with a countifs statement but can't seem to get it to work. Thank you in advanced for your help.

 

[bbott]

Welcome to the board.

Assuming your table starts in A1, try:

=COUNTIFS(C2:C5,163,L2:L5,">0")

 

[Crdtk8]

Welcome to the board.

Assuming your table starts in A1, try:

=COUNTIFS(C2:C5,163,L2:L5,">0")

Thank you so much, I feel silly that I didnt think to try it that way, but it worked perfectly! I apperciate your help and speedy response.

 

[bbott]

Thank you so much, I feel silly that I didnt think to try it that way, but it worked perfectly! I apperciate your help and speedy response.

You're welcome.