Hello,
I am trying to figure out a way to add together multiple values after the formula finds text in a cell the next column over. I attached an example workbook.
The code will need to search column G for the word 'cancelled' and if found then add the value to the left of it. I have a working index/match formula (its included in the example workbook on I4) but it only returns the first value when it finds the word 'cancelled'. I am needing a formula that will add all values to the left of the word 'cancelled'. Sometimes the word may appear 10 times and the formula will need to add together all 10 values, after finding the matching text in the next column over.
Just a quick note- the values and data will change many times without closing the workbook. We are using this to generate a PDF for the total of all cancelled files for multiple employees. When we put in new info all values and the amount of cancelled/active loans will change drastically. That will happen about 40-50 times without closing the workbook.
Thank you for looking at my issue and in advance for any help. I have never created a formula that adds multiple values based on index so I am stumped.
Bookmarks