| I like the simplicity of the first one|
But you may give up speed for simplicity,
because you will be checking a LOT of cells that are empty.
I always advise against using the shortcut form of A:A to sum a whole column
this is basically the same thing, so I would advise you use the Dynamic Name Range solution. It may take a few seconds longer to set up, but in the long run it is the better of the two option. In my opinion.