1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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

submitted by /u/jkvlights
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#financial modeling with spreadsheets
#natural language processing for spreadsheets
#Excel alternatives for data analysis
#rows.com
#generative AI for data analysis
#Excel compatibility
#row zero
#natural language processing
#Excel alternatives
#counter
#logistics
#value
#materials
#column
#dates
#cell range
#excel
#total days
#information
#restart