Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I do a MAXIF similar to SUMIF and/or COUNTIF? Please Advise | Excel Discussion (Misc queries) | |||
similar to sumif() but for averages | Excel Discussion (Misc queries) | |||
A formula maxif, similar with sumif or countif | Excel Worksheet Functions | |||
Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
sumif with similar cells | Excel Worksheet Functions |