Sum of sums

Hi @aleksandra_budnik!

Normal formula for addition is ‘=SUM(D3:X3)’
This formula works well when we know the upper limit. But, how can we add the values in a row when we don’t know the upper limit?

P.S.: I cannot use ‘=SUM(3:3)’ because the row contains data other than numbers.