=SUMIF(CLIENT!I2:I378,"CHAMPION TITLE",CLIENT!Q2:Q378)

I have multiple formulas where the final number "378" changes daily in my
spreadsheet

what is the best way to update all the formulas on my calculations page
I would like to possibly link to a number on a the sheet so that it
automatically applies to all necessary areas

The sheet that i am drawing data from is "CLIENT" and the sheet i have
formulas on is called "calculations"