From numbers in a column, sum only those that are consecutive.

[gdougher]

I have a s/s for billing that I use when submitting claims in an application that only allows input for a single date, or, if dates are consecutive, I must sum the amounts in order to enter the line item.

For example: John Doe for the month of September
9/1/2022 $13.96 Amt Claim Line 1 = $13.96
9/8/2022 $13.96 Amt Claim Line 2 = $13.96
9/12/2022 $13.96) Amt Claim Line 3 = $27.92


9/13/2022 $13.96)
9/15/2022 $13.96 Amt Claim Line 4 = $13.96
9/26/2022 $13.96 Amt Claim Line 5 = $13.96
9/29/2022 $13.96 Amt Claim Line 6 = $13.96

Is there a formula I can use that will do this for me through the 500+ rows in my s/s?