You have two options that I can think of: one is to convert the table into a structured Excel table which will force formulae to copy down when you add rows, the second is VBA.