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,
Bookmarks