(Click image to enlarge) This return to law firm costs amount to bill each client still loading the data in a disorderly manner.
formula = SUBTOTAL (9, A3: A494, D3: D22) that appears in the formula bar partial sum totals per customer.
In the title bar added a AutoFilter .
When choosing a client from the list, for example, "Camino del Sol" - EXCEL shows the total for that client.
AutoFilter tool to extract valuable information, for example, and in this case, the total spent between two dates or 3 more customers owe us.
