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

[dougkpga]

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

[Glenn Kennedy]

To get rid of zeros:
=IFERROR(1/(1/(C2/A2*100)),"")

[Glenn Kennedy]

Count:
=IF(B2<>"",MAX(C$1:C1)+B2,"")

[dougkpga]

Thank you Glenn for the help.

I'm usually happy with what I can do on excel and then I see how good you guys are I have a lot to learn.

[Glenn Kennedy]

LoL. You're welcome!

[dougkpga]

I had a friend over here in Australia called Bryce Kennedy. He tragically died of cancer with a young family but he found Jesus before he died.