I was wondering if there's a formula or code that could give the correct
result to the following:

I want to be able to add the corresponding amount from column C whenever
column A ends with the word Sum. In my example below the answer would be
5000.00. I thought about using the right function and then the sumif
function but I'm hoping there's an easier way.

Column A Column C
04-400-0527. Sum 1000.00
04-400-0528. Sum 1000.00
04-400-0529. 1000.00
04-400-0530. Sum 1000.00
04-400-0531 1000.00
04-400-0534. Sum 1000.00
04-400-0544. Sum 1000.00