I could use a hand here on what I think is a sumproduct need. I have a table where I'm only interested in counting the row when a value occurs for the first time. See the top row of the picture here for the formula solution needed. The end goal is to get a running total of the number or rows that has a value each day but only until the first value occurs. Once that first value occurs, there's no need to add additional values. I appreciate any help.
thank you
picture link
https://www.dropbox.com/s/0x57jnfsmias4vg/Picture2.jpg?dl=0
thank you
picture link


Last edited: