Looking for a way to do a progressive count (gaps in the cells to be counted)

I have a column that I would like to keep a count on.

The cells sometimes contain 1 and sometimes are blank.

Is there a formula to add the 1 to the previous total please?

Also is there a way to remove the zeros in Column D? % Formula used is below.

A simple spreadsheet is attached.

Thanks for any help.


Total Score Progress Percentage =C2/A2*100

1 1 1 100
2 0
3 0
4 1 2 50
5 0
6 1 3 50
7 0
8 1 4 50
9 1 5 50
10 0