Compound Condition in SUMIFS

[pliskers]

I would like to write a SUMIF formula that will sum the values in column B for all rows in which the rightmost character in column A is a number. I've tried a few combinations but am getting only zeroes in the result. Any thoughts?

Thank you in advance!

 

[etaf]

how about
=SUMPRODUCT((B3:B5)*(ISNUMBER(RIGHT(A3:A5,1)*1)))

Book1
	A	B	C
1
2
3	abc1	1	5
4	abc	2
5	abc	3
6	4	4
Sheet1

Cell Formulas
Range	Formula
C3	C3	=SUMPRODUCT((B3:B6)*(ISNUMBER(RIGHT(A3:A6,1)*1)))

 

[pliskers]

I solved it myself using just about the identical formula. Thank you!