Search results

I dont really get it, Could you make this clearer if i give an example table? Column A is the description Colunm B is the ammount i have to pay to that company I want to find every occurance of "british gas" in col A and total up the figures in Col B to get a total spend for british gas...

Its been a long time since i have used excel and i cant remember even the simplest things :/ So i want to total up figures with a description beside them from my bank statement which i have in excel format. I just want to be able to see how much cash has been drawn out, card payments made etc...