Using sumif and changing Table Range

I am using the following table range called Table14 and its range is =$A$1:$R$126 on a tab called ALL.
Also the last row in the table range has the column totals expect for column A.

Column A (Name) and R (Total [Number]) are the ones I want to use for calculation purpose in another tab called Total

I want to use sumif function based on the Table range and excluding the last row for the Column Total.

But I don't want to update the range function every time I update the Table14 range by adding more data
SUMIF( range, criteria, [sum_range] )

But I don't know how to use the sumif function to sum the range of Column R
=SUMIF(Table14,Sam,???)