How to Sum based on partial match of a cell in number format (not text format)

Hi, I don't know how to sum based on a specific number string of a cell.

My data is (for example):
1000.2350 (398.46)
1000.2360 (131.35)
1000.2370 (305.48)
1000.2380 (415.67)
86.5010 9,092.16
86.5020 3,634.63
86.5030 970.01
86.5048 11,178.25
86.5060 (1,454.13)
86.5070 53.78
86.5080 1,787.84
149.5010 3,057.78
149.5020 567.31
149.5040 2,870.21
149.5060 (523.79)

I'm trying to sum all values from Column B that match .5048 from Column A. My problem is that I cannot have Column A formatted as text. I have to have it format as numbers, so I don't think I can use wildcards. Any suggestions? Thanks much!

Assuming your data has header in row 1.

Try something like below.
=SUMPRODUCT(ISNUMBER(FIND(".5048",$A$2:$A$16&""))*($B$2:$B$16))

By concatenating Column A with "" blank, it converts numbers to text.

CK76 - This worked perfect! Thank you so much!!!! You made my day.

here another option: =SUMPRODUCT((RIGHT($A$1:$A$15,4)="5048")*($B$1:$B$15))