I have a worksheet having claim numbers in column A invoice numbers in column
B and invoice amoiunts in column D. A single claim may have one or more
invoices

How can I have claim totals/sum/amount in column M?(Prefarably in the same
row as the last invoice for each claim)