SUM between Cells as a fillable function

Copper Contributor

I am looking for a fillable function to SUM Colmun5 between the first "Break" row in Column6 & before the next "Break" row when column 8 is "00:00:00" and skipping the gray "[Date] Total" rows values?

 

MambaMentKC_0-1681943318148.png

 

All help is appreciated!

 

1 Reply
Share the sample file here to the post.