I have a sheet with bank statements and a want to set up a summary sheet with the total amounts per client.
I know how to do that from within the statements sheet, e.g. summing up client A:
=SUMIF(B1:B,A1:A,"A")
But how can I do it directly from the summary sheet? Is there a way?