How many values between other values (count number cells between two of the same text)

[nearbeer]

Thank you for taking the time to look at my question.

I have a production query that returns several columns of production data; see the example below:

Scan Date	Operation Type	Product Code	Machine #	Workpost #	Barcode Serial Number
09/19/2014 23:49	CA	CARCJ80S2586	S2	F01	58625478
09/19/2014 23:49	CA	CARCAF0T1658	T1	F01	65804077
09/19/2014 23:28	CA	CARCAF0T1658	T1	F01	65804076
09/19/2014 23:29	CA	CARCJ80S2586	S2	F01	58625477
09/19/2014 23:31	PR	FECX187029	S2	FEX	17092014-A85
…	…	…	…	…	…
…	…	…	…	…	…
09/19/2014 22:58	CA	CARCAF0T1658	T1	F01	65804070
09/19/2014 16:29	CA	CARC9L0S2688	S2	F01	68850901
09/19/2014 16:23	CA	CARC9L0S2688	S2	F01	68850900
09/19/2014 16:20	CA	CARCAF0T1658	T1	F01	65804012
09/19/2014 16:24	PR	FECX166884	S2	FEX	18092014-D14

<tbody>
</tbody>

What I need to do is count the number of “Barcode Serial Numbers” between “Workpost #” on the same machine; IOTW, for S2 (Machine # column) I need to count the number of products that start with “CARC….” from the Product Code column which occur between “FEX” in the “Workpost #” for the same machine.

What makes this a bit complicated is that there are multiple values for each workpost (not just F01 & FEX). I need to be able to figure out for each machine number, how many “CARC” were made in between “FEX”; in this case it is (2)…I have deleted a number of rows to clean up the sheet a bit.

Again, I appreciate your help!