Results 1 to 4 of 4

Date Range filter

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    5

    Date Range filter

    Hi There

    I have successfully made my excel sheet with the purpose of identifying the total income for a given month in a year for cash flow purposes. This basically works with a column that creates a number for the corresponding month (eg august is 8) then a filter to add up all the payments from that particular month. We now need to do this over two years so i need to add a year function to it but can figure it out.

    My current set up is:

    A list of income payments in one column and the date received in a separate column and the month ID column in the third
    Payment column is named Income - this has my input figures
    Date column - is un-named an has the date input
    Month identification column is named Month_Income - and uses formula =MONTH( x) where x is the cell with the date

    In a different row across the top - i have the months Jan - Dec and below each month i have a cell telling me the total income for that month using:
    =SUMIF(Month_Income,"=x",Income) - x is the corresponding month eg 8 is for august.


    So now i have added a fourth column with the year named Year_Income and a formula =YEAR(x) where x is the cell with the date input.

    What should the SUMIF formula look like to include my year? Ie so i can see the total income for august 2012 or july 2013 etc.... ?

    Thanks

    bruce,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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