Accumulation Formula for Rangesum

[RedStinger55]

I have an issue with a RangeSum formula leaving blanks in my data, I would like my formula to fill in the blanks with the previous column if that is possible. 

My current formula is: RangeSum(before(TOTAL Count([Field]), 0, columnno()))

Thanks for the help

[Kushal_Chawda]

@RedStinger55  Would you be able to share sample?

[RedStinger55]

@Kushal_Chawda Above I provided a screenshot of the blanks and the formula I am using. If you read the top row which is the total, the <=10% is missing 9, but it should just be carrying over the 9 from the <=8% column.