I am attempting to assemble a spreadsheet which will add player stats from a football match, from 2 different tables into 1.
The tables are organised so that the playername is at the start of the row and the various starts follow it up. My issue with the formula is that certain players don't record any stats in a game and thus will not appear in one table but may appear in another.

What formula would i be able to use, adding stats, based on the name at the start of the row?

thanks