I am looking to find the easiest formula solution for the following.
I wish to check if table a5:a32 contains the word "MTD", if so, it takes data from a cell in the same row from column F and then sums it in a seperate cell.
so if i had 5 MTD, 5 values would be summed together and not include the rest of data in column Feg.MTD xxx xxx xxx xxx $50MTD xxx xxx xxx xxx $20
MTD xxx xxx xxx xxx $10XXX xxx xxx xxx xxx $05 total $80
Thanks in advance
View best response
If I am understanding you right, try this formula:
Change A to your desired column where the MTD text is located.
Change B to where the $ column is located.
Basically, this formula will do what you have asked.
I have also attached a sample file to demo the above for you to see it in action.
Let us know how you go?
Works exactly as requested. Thank you