I have two columns of data, one column will have either "cc" or "cash" in each cell, the second column will have $amounts. I am trying to have it automatically know whether each dollar amount is associated with "cc" "cash" other words, whether "cc" or "cash" is in the cell next to the amount. I then would like it to fill the totals from "cash" and "cc" into specified cells.
Any help with this would be greatly appreciated.
Thank you!