LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default sumif formula or similar

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I do a MAXIF similar to SUMIF and/or COUNTIF? Please Advise Sathya2 Excel Discussion (Misc queries) 1 November 15th 07 08:48 AM
similar to sumif() but for averages Donovan Excel Discussion (Misc queries) 6 August 5th 06 12:25 AM
A formula maxif, similar with sumif or countif Dan Tacu Excel Worksheet Functions 1 June 6th 06 05:30 AM
Is there a MAXIF formula similar to the SUMIF formula? tlc Excel Discussion (Misc queries) 2 March 13th 06 08:07 PM
sumif with similar cells Mosqui Excel Worksheet Functions 5 August 20th 05 07:50 AM


All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"