Array formula - nee help

L

linh091

I have this file and need to count the continuous date value (=1)
I already made for each month but cannot make for several months.
Now I need to help: how to make formula for B70 have the result as th
same B71
this file is generated automatically from an old software, and thi
sheet is very big and complicate with multi-cell, multi-table... Hence
it really hard to delete the gap as you can see because the tables ar
placed alternately

I just need: much better if there is a way can be inserted or combin
into the old formula a small formulas to be able to remove the characte
is not 0 or 1

https://www.dropbox.com/s/nuv9eqfnmrnvlft/Caculation the continuous date value.xlsx

Thank yo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top