Add right most value ONLY if a number

[bordensize]

Good afternoon,
I'm trying to come up with a formula to only add the right most value of an array or cells if the values are numbers (and these numbers will only ever be 1, 2, or 3.) I've managed to come up with making sure all values are computed as numbers, but I cannot figure out how to ignore actual text values from the array to compute the way I need it to.

=SUMPRODUCT(IF((A1:A8)<>0,--RIGHT(A1:A8)))
This formula works if the column doesn't include any values ending with text (such as '2p' below,) but my column will almost always have multiple cells with values that end in text that I'd like to ignore.

Thoughts?

1   
2   
3   
p1   
p2   
wjp1   
flf2   
2p   
    
#VALUE!    Sum

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=SUMPRODUCT(IFERROR(--RIGHT(A1:A8),0))

 

[bordensize]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=SUMPRODUCT(IFERROR(--RIGHT(A1:A8),0))

I updated my info. Excel 365.

Also, yes that formula worked. Now I'm irritated that it was that simple.... Much appreciated!

 

[Fluff]

I updated my info. Excel 365.

Thanks for that

Also, yes that formula worked.

You're welcome & thanks for the feedback.