Simifs between a range

Hey Guys,

Hoping someone can help been going round in circles trying to figure this out. I have attached a test sheet to help explain

Looking to have a formula that can do the following

In Cells in G:G If the Corresponding Cell in F:F = "Yes" then sumif if the Cell in B:B is in the Range E:E it should sum the Values in C:C but only between the starting 0 in column A:A and the ending column where that cell in G:G lies between in A:A.

For EG: in cell G155 the 1st '0' in column A:A is in A141 and the last is in A177
so as F155 = "Yes" the formula should sum the values C170:C173 as the value in B155 matches those in E170:E173 it should = 1334.205

Likewise the Value in G2 should = 20,290.18
G8 should = 29,793.04

Any and all help greatly appreciated.

Many thanks in advance