Well, if you can show what calculations you want to do, I might come up with something. One thought, if the start of the row is all zeros, you can certainly sum up the whole row with SUM(A1:J1), you don't need to skip the 0 cells.
I have these two rows:
29-09-18 30-09-18 01-10-18 02-10-18 03-10-18 04-10-18
52 62 14 52 63 73
In the third row, I want a function that will compare the date in the first row and the same column, with another date in an independent cell.
If the independent date is before then fill with zero. If it is after, then I want to do this:
1) calculate the sum of the second row for the range of the cell that belongs to the column that the third row cell is the first non zero, up to the end of the second row.
2) I want then to drag that formula for all the cells in the third row, so that for each cell, it will check the date two cells above with the independent date and fill accordingly. But if the independent date is after, I want to fill with the same sum every time, which is the sum of the second row cells from the column that the third row is the first non zero, up to the end of the second row.
In fact, I want to use that sum to do some more calculations, but I can figure that out later.
Any idea? The tricky thing is how to make the formula in the third row, to scan the left cells, identify the one with the first non zero value and use that reference so that it will calculate the relevant sum in the second row.
It's so tricky! I might have to use an additional line, but if you can come up with a better idea? I am not aware of all the functions in Excel so I don't know the capabilities and limitations.