|First, I'm not quite sure why you typed out the formula in words instead of just pasting in the actual formula. It would have been easier for you and easier for us.|
Second, I pointed out the link to the instructions on how to post example data in this forum. You don't need to post an image, you can post actual data.
Third, you've confused me again. You originally said that you wanted to reference O:AG. I therefore suggested an OFFSET function with a cols argument of 11 and a width argument of 19. This formula will always SUM O:AG even if you insert cells before Column O.
Now it sounds like you only want to SUM R:V. If that is the case, why did you use a width argument of 18? The width argument determines how wide the referenced range should be, starting with the column determined by the cols argument. i.e. how many columns to SUM.
If you only want to SUM 5 columns, then you should be using a width argument of 5. If you use 18, the formula will SUM 18 columns, starting with R. Your formula will always SUM R:AI.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.