How can you calculate the product of non-empty rows up to the current row?
I'm trying to write a column formula that will calculate the product of all of the (non-empty) rows up to the current row.I've attached an example data table (& screenshot). I am trying to get the "Product" column to be the product of all of the non-empty rows from the "Value" column. I show the manually calculated result and math in the "Desired Result" & "Desired Result Explanation" to the right...