Counting if few conditions are met until further condition is met starting from last entry

[StevanBgd]

Hello everyone,
I am using Excel 2007 on Windows 10 and have some troubles with counting in excel. I will explain it in example:
DATE 1ST 2ND SHIPMENT
01.01.2020 Apple Banana yes
01.02.2020 Banana Apple yes
01.03.2020 Orange Banana no
01.04.2020 Apple Orange no
01.05.2020 Apple Orange yes
01.06.2020 Orange Banana yes
01.07.2020 Banana Apple yes
01.08.2020 Apple Orange yes
01.09.2020 Apple Banana yes
01.10.2020 Banana Apple yes
01.11.2020 Apple Banana yes
01.12.2020 Apple Orange no

I want to count several things:
1) how many times combination "apple" in column 1ST and "yes" in column SHIPMENT appears until column SHIPMENT turns "No" starting from last entered combination?
2) how many times combination "apple" in column 2ST and "yes" in column SHIPMENT appears until column SHIPMENT turns "No" starting from last entered combination?
3) how many times combination "apple" in column 1ST or column 2ND and "yes" in column SHIPMENT appears until column SHIPMENT turns "No" starting from last entered combination?
Example is also attached as mini-sheet.
Thank you for help.
Kind regards

Counting mini-sheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	DATE	1ST	2ND	SHIPMENT				Number of consecutive "yes"			Number of consecutive "no"
2	01.01.2020	Apple	Banana	yes			1ST	2ND	BOTH	1ST	2ND	BOTH
3	01.02.2020	Banana	Apple	yes		apple
4	01.03.2020	Orange	Banana	no		banana
5	01.04.2020	Apple	Orange	no		orange
6	01.05.2020	Apple	Orange	yes
7	01.06.2020	Orange	Banana	yes
8	01.07.2020	Banana	Apple	yes
9	01.08.2020	Apple	Orange	yes
10	01.09.2020	Apple	Banana	yes
11	01.10.2020	Banana	Apple	yes
12	01.11.2020	Apple	Banana	yes
13	01.12.2020	Apple	Orange	no
Sheet1