Results 1 to 6 of 6

Sumif by Account and Date

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2005
    Location
    Louisville ky
    MS-Off Ver
    2018
    Posts
    85

    Sumif by Account and Date

    Worksheet 1:

    Column A a listing of various Accounts of income producing properties; there are 7 "unique" accounts

    Column B a listing of dates of deposits or withdrawals from those accounts

    Column C & D the types of deposits made each day (if any) into each account, with C being via cash and D via check

    Columns E, F, G, H, & I the types of withdrawals by dates from the accounts such as interest paid, taxes, fees distributions to beneficiaries of the various accounts, etc.

    Worksheet 2:

    Column A the same list from column A from Worksheet 1

    Column B the various months (as opposed to days) of the various Account activities (i. e., deposits and/or withdrawals) listed on Worksheet 1

    What I am looking for is a formula for each cell columns C through I in Worksheet 2, by month

    Any help?

    Thanks in advance
    Last edited by jlkirk; 03-19-2024 at 09:01 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 07-25-2021, 05:52 AM
  2. Looking up delivery date after order date... for a certain account number
    By tangcla in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2016, 01:18 AM
  3. Replies: 7
    Last Post: 07-10-2015, 10:30 PM
  4. Replies: 3
    Last Post: 02-13-2014, 03:42 PM
  5. SUMIF by Date - SUMIF by Date = #VALUE when linked worksheet not open
    By alexhartley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2013, 03:56 AM
  6. Replies: 1
    Last Post: 09-07-2012, 12:00 PM
  7. [SOLVED] Sumif of a range i.e between account codes 100 - 500
    By Hesh in forum Excel General
    Replies: 5
    Last Post: 06-18-2012, 07:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1