What formula can I use if I have a row of values where each previous cell to
the left is added until a tested criteria changes?

For example, row A1 to E1 looks like this:

0,1,0,0,1

I need a formula in row A2 to E2 that tests each of the above cells. For
example: B2 will add the values of A1 and B1, because there are only '0's,
(as in 1 '0'), to the left of B1. However, E2 will add the values of C1:E1,
because the values of C1 and D1 are not '1'. A1 and B1 are not included,
because B1 is a '1'.

In other words how can I write a formula that tests if an adjacent cell meets
a criteria? If it does, the formula tests the next cell in the row to see if
it meets the criteria and so on until the formula encounters a cell that does
not meet the criteria is encountered?

For an example, I've upload a simplified spreadsheet to
www.linkm9.com/help2.xlsx
You can refer to this spreadsheet in your reply.

Thanking you.