Trying to create a formula that will sum 5 cells to the right of the
cell in question if the cell the cell in question contains a Numerical
value, and that will do nothing if the cell in question contains text.

I have gotten as far as:

IF(TYPE(1), SUM(C6513:M6513), "")

Obviously, "" does not return the same text originally in the cell, but
instead a 0.