J
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)
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)