Hi

Can you give a visual on the layout of the spread sheet or email it to me
Because there are several ways to solve this

Thanks


"Joco" wrote:

I use a spreadsheet to keep tract of payments and receipts to my bank
account, Relevant columns are

E Payee or Sender
F Credit entries entered with a - value
D Payments

Each month I have payments and receipts into a number of different savings
accounts, and are trying to get a single net total for all the savings items.

Is it possible to enter the account names in a list, and have the formula
refer to the list, when checking which items should go into the total.

I currently obtain this total with a very long sumif formular, which is now
difficult to control due to the number of different savings accounts.

Any help would be appreciated

Thanks Joco (London)