sumif formula or similar

[Joco]

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)

 

[CmK]

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]

Hi,
Spreadsheet layout has the following columns

a = spare coulmn (blank no data)
b = column with formular showing "today " or "tomorrow"
c = date formated ddd dd-mmm-yyyy
d = reference column, cheque no, direct debit or standing order
e = whom I pay or receive funds from
f = receipts entered as a - value
g = payments, no sign
h = cummalative book balance
i = input field (3 formatted to a tick) when item shows on bank account
j = formular for actual bank balance
k = spare column (blank no data)
l = formular on the last day of the month line, showing monthly net savings
figure
m = formular for savings movement year to date, shows on each line

Its columns l & m, that I am trying to replace the formula in

Thanks Joco (London)