Trying to Find the Correct Lookup Function

[maplemeadows]

I am trying to find a formula that would be best to use for this scenario.

This is a just a test scenario where I am looking to find all dates (1-Jan-25 in this case) and return the cost of all the dates.

The end value should be $28.

 

[dermie_72]

=SUMIFS(B:B,A:A,A2)