SumIF formula based on text in Cell

I am trying to create two formulas that will do a sumif funciton based on 7 characters of text starting a cell.

In my Data Dump tab, Column O, if 'RRN 622' starts the reference cell, then I would like to create a formula that brings the date from column A and the amount from column H to my Summary tab.

Any and all help is greatly appreicated.

If you have any questions or need further clarification, please let me know.

thank you,

I inserted a "helper" column into your data to make this easy. Inserted a new column O with this formula in O2, then copied down:

=IF(LEFT(P2,7)=RRN!$C$2,MAX($O$1:O1)+1,0)

Then standard lookup formulas on your Summary do the work. Note the two helper cells in yellow on that page, too.