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)

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)

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)



"CmK" wrote:

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)