Summing From a Date to a Desired Cell Value

Hello Everyone,

I am trying to sum values in a table starting from a certain date range and ending when the values bceom zeros again. I have attached an example to better clarify. I was hoping this could be done with functions. Any help would be much appreciated!

Thanks!