Find specific text at end of cell (i.e. Ends in "-2")

This has to be easy, but I can't figure it out. I am trying to determine if the cell ends in "-2". If it does, "Shared" if it does not, "".

I found this in another post and thought it might work, but didn't: =IF(ISERROR(FIND("-2",D1,1)),"SHARED","")
I also found this, and it didn't work either because of the "-" in front of the 2. =ISNUMBER(FIND("-2",D:D,LEN(D:D)))

Excel has a built in function to filter by cells that end with a certain criteria, so it has to be possible.

My end goal is to throw this into an ifs() formula:
if the cell D1 ends in "-2", then countifs(A:A,B1)

I can get the bandaid if someone can help with the "-2" part.

Thanks for the reply- just so I understand why, can you explain the =if(right(D1,2)...?

I don't understand the logic for that part. Why the #2?

I have having issues with this when I try to SUM all the cells that meet that condition.

=IF(LEFT(B2:B71,1)="H",SUM(C2:C71),"ERROR")

See the attached spreadsheet. I also have 3 goals I am trying to do that are explained on the spreadsheet. Can you help me with those formulas?

Here is the attachment

Perfect- Thanks.