Formula finds the max number of consecutive times and the Total of consecutive values

The formula finds the maximum number of consecutive times and the sum of consecutive values between 1 and 0

The maximum number of consecutive times in the marketing department is 3, and Total amount 38974
The sales department's maximum consecutive times of 6, and Total amount 193058


Thanks for any help !

With two helper columns D & E

try this

In D2

Please Login or Register  to view this content.

and drag down
In E2

Please Login or Register  to view this content.

and drag down

then in G2

Please Login or Register  to view this content.

(as an array formula so hit control + enter + shift
then drag down to G3


then in H2

Please Login or Register  to view this content.

(just as a normal formula this time) and drag down to H3

ARRAY formulas are used.
In G2 then copy down

Formula:

Please Login or Register  to view this content.

In H2 then copy down

Formula:

Please Login or Register  to view this content.

To enter ARRAY formula
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.