Hi everyone,
I'm trying to create a spreadsheet to summarise some costs. Column A has the type of transaction, (DD or POS plus some more) Column B has the name of the transaction (Tesco, Sainsbury's, etc) and Column C is the value in £'s.
I need to search for all transactions placed by Tesco, filter out the DD's and then sum the remaining POS transactions into a single total.
I'm sure this is possible using vlookup and sum or sumif.. but I've been trying all morning and can't get it working!
Thanks in advance.
Andy
Bookmarks