Agreed, Numbers can do much of what Pages can do in terms of text and graphics but with all the functions of a spread sheet.
Actually, Pages will do this too. You have to create the Table on the Mac as the iOS version of Pages won’t do formulas. But once you have it set-up on the Mac you can edit on an iPad and the calculations will update. So it’s possible to just copy/paste/insert new rows/columns that will continue calculating.