If you read my post more carefully, I suggested COUNT as a diagnostic
function; if count is zero, then SUM is failing because it is not seeing
any numbers.

Jerry

Bryan Hessey wrote:

As you are looking for the sum total the Count function will not assist
you.
You can sum the 'trim'ed values with

=SUMPRODUCT(VALUE(A5:A50))