You can use a range formula for cases like this. The relevant section in the manual, which you can get to with C-h i g (org) Field and range formulas, says:
Range formula, applies to all fields in the given rectangular
range. This can also be used to assign a formula to some but not
all fields in a row.
That, combined with relative ...