Using rSum To Add Multiple Cell Groups

I've been running into issues with this. For some reason, I'm unable to copy and paste data within this sheet now, and I am also not able to use the =rSum((A1:A10,C1:C10)) formula once the range is interrupted by a non-numerical cell, it seems...

I've attached a sample of the worksheet. The four cells that need this formula are coloured on the top left with their respective cells the same colour on the right. The cells on the right will be continued towards the right in that pattern and will continue indefinitely.

Also, how do I select an infinite range of cells? You'll see that the codes I'm attempting to use are in the format of =rSUM((I10:AAF10,I18:AAF18)) - is there anything else I can use besides some crazy cell number like AAF10 and AAF18? I'd like the whole row from I10 and I18 on to be part of the formula.

To clarify, the code and formulas I'm currently using I've received from this thread here which allows numbers that receive the strikethrough feature to be subtracted from the subtotal; and they worked great until I realized that there won't be an uninterrupted flow of numbers in the ranges used.

Any suggestions?