I have a list of around 3000 customers, each with around 100-105 costs against them. i want to add the entire column of cost, sorting according to customer. I know I can use an IFSUM criteria but as far as i can see i would have to type out all customer names seperately. Is there a way to sort all that? I guess the criteria would have to be "if text is equal to itself then sum". Please help i have a deadling and will lose my mind if i do it manually