I saw this Question and kept on wondering how do I apply this if I wanted to add different cells in a row. For reference, I am creating a lot of tables per day, each has 3 categories, namely: Cost, Clicks, Signup. I want to be able to create a formula where even though I add new table to the right, data will be automatically added to my Total Sum without manually adding it.

Apologies if my question is too difficult to understand. But here’s a Practice Google Sheet for your reference.

Thanks!

I tried using the given formula from the cited previous question above, but there’s no clear explanation with how should I apply this if there was only selected cells in a row and not actually adding the entire row. Help pleaseeee. Thanks a lot!