Sum Longest streak with IF condition

[carlitosz]

Hello,

Based on this previous thread: Sum longest streak

I have this data set, very similar problem, but with a change in orientation:

Total Shifts In Row	Consecutive Hours	11/14	11/15	11/16	11/17	11/18	11/19	11/20
5		5.43	8.47	8.30	6.83	7.63		5.38

This data goes from D2 (Total Shifts in a Row) to L3 (5.38)

I'm using this in Column D3 to help calculate the max consecutive shifts, which is working perfect.
=IF(arrayformula( max( len( split( join( "", left(F3:AC3 > 0) ), "F" ) ) ) )=24,0,arrayformula( max( len( split( join( "", left(F3:AC3 > 0) ), "F" ) ) ) ))

What I'm looking to get is IF the employee has worked 5 or more shifts (Column D3), then calculate the SUM of the consecutive 5 or 6 days hours worked.

In this case this employee worked 5 consecutive days between 11/14 and 11/18 and the formula on column E3 should provide a total of hours worked of 36.67.

I can't figure this out! I'm using Google Sheets.

 

[Armstrong_N14]

I'm using 365 Installed on a PC. Not sure if this will work on google sheet, but I guess the idea should help (hopefully)

Book4
	D	E	F	G	H	I	J	K	L
2	Streak	Hours	14-Nov	15-Nov	16-Nov	17-Nov	18-Nov	19-Nov	20-Nov
3	5	36.66	5.43	8.47	8.3	6.83	7.63		5.38
Sheet1

Cell Formulas
Range	Formula
G2:L2	G2	=F2+1
D3	D3	=COUNT(F3:INDEX(F3:L3,MATCH(TRUE,(F3:L3=""),0)))
E3	E3	=SUM(F3:INDEX(F3:L3,MATCH(TRUE,(F3:L3=""),0)))
Press CTRL+SHIFT+ENTER to enter array formulas.