I have a Sheet which contains a complete list of all invoices, which Customer they are for, the Invoice Total and an Invoice Paid column which would show the balance of the Invoice. I have created a number of Filters for all of my Customers, so that I can filter straight to one Customer and see their outstanding balance. This creates a statement for me.
Is there a way of calculating the sum of the Invoices that are filtered? At present, the range it is trying to calculate is all of my rows whether filtered or not.
Any help would be great 