Cp Right Before Menstruation

horizontal sum autofilter subtotal and customer spending

(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.