Search results

sumif is useful but if there are inconsistencies in suppliers (ie typos) then it will not include them A pivot is probably the way forward as you'll get a total for each supplier and you will be able to give it a quick scan for any inconsistencies and amend accordingly before refreshing. Just...