I have a row with dates that are start of weeks ongoing. Below that, I have one row with numbers. Below that, I have a row that I want to fill in with a formula.
In an independent cell, I input a date. Then the formula I want to fill in, checks if the date is future/past of the date at the top row in the same column. If future, it fills the cell with zero.
The problem is what I want it to do if the date is past.
I want to display the ratio of the number above in the middle row and the same column, with respect to the sum of the middle row numbers. The tricky bit is what exact sum I want it to consider.
I want the sum of the first cell in the column that the bottom line cell is not zero, up to the end of the row.
I need somehow to reference and store in a variable that. Or somehow calculate that ratio, considering the right sum, which is fixed once defined, but it is defined by the first cell that gets a non zero value.
I don't want to do this with a macro as I don't know anything about macros. Any help?