How to create a counter
Hello everyone! It's my first job and I'm working in the logistics department. I need some help with how to create a counter, let me explain. (Sorry for the English, it's not my first language)
I have a list of materials in the column A, and in the next columns is the dates, like 18/mai, 19/mai and so on with informations of value. The informations that I have can sometimes be 0, and I need a counter that shows me how many days it has a value in the cell range, and if there's an 0 in the middle of it, the counter restart.
I'll try to put the example in the comments, the G column is the total of days it had an value in the row and when the 0 (the ones with - and painted in yellow) is in the middle, it restarts. The red numbers are the ones being considered to the total
[link] [comments]
Want to read more?
Check out the full article on the original site