I need help with a formula please...

[ridge]

I am using a "sumif" formula, where i need to recognize the last digit only, which is also the 2nd digit right of the decimal. I have tried the asterick and also the question mark in various ways.
The formula will recognize the figures when I use the entire number, so i feel as though the rest of the formula is correct. Any ideas as to why I can't get only the last digit recognized?
IN THIS EXAMPLE, I NEED TO RECOGNIZE THE NUMBER 54900.91
BUT ONLY THE LAST DIGIT IS THE ONE THAT MATTERS.
SUMIF((A2:A99),"*.?1 ",(B2:B99))

 

[repete]

I tried this

Data in col C, rows 2 & 3.
Formulas in col C, row 3; and in col D, rows 2, 3, & 4

COL C COL D
ROW 2 56.23 =+VALUE(RIGHT(C2,1))
ROW 3 63.25 =+VALUE(RIGHT(C3,1))
ROW 4 =SUM(C2:C3) =SUM(D23)

These are the answers

COL C COL D
ROW 2 56.23 3
ROW 3 63.25 5
ROW 4 119.48 8


It's not your answer, but it may help.



Pete Bloomfield
Down Under