Thanks for many helps.

Sorry that if SUMPRODUCT() is really to be used (as a good knowledge), how can I add another condition in this function to allow for cases with #NA? I tried to use:

=SUMPRODUCT(--(LEN($A$1:$A$5)>0),ISNUMBER($A$1:$A$5)) But not working