+ Reply to Thread
Results 1 to 4 of 4

Sum a sequence of dates

  1. #1
    Registered User
    Join Date
    03-29-2005
    Posts
    48

    Sum a sequence of dates

    Hi, I have a spreadsheet with 5 years of data. The dates in column B and the amounts in column O. At the bottom I want to build a summary of what happened in each fiscal year. The fiscal year runs from April 1 - March 31st. What would be a good formula to use to capture the sum of the data for each fiscal.

    Thanks,
    Attached Files Attached Files
    Last edited by billy2willy; 02-14-2013 at 05:19 PM.

  2. #2
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: Formula question

    Perhaps using indirect or normal sum function by selecting multiple sheets works here. To build a formula, will have to look into a sample data set though....
    If solved kindly remember to mark Thread as solved.
    Click the small star icon at the bottom left of my post if this was useful.

  3. #3
    Registered User
    Join Date
    03-29-2005
    Posts
    48

    Re: Sum a sequence of dates

    No thats to simple. I need a formula that can grab the dates if certain coditions apply and then add up the values. Please see the attached spreadsheet

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,626

    Re: Sum a sequence of dates

    Pl see the attached file with formulas is r & s columns.
    Attached Files Attached Files

+ Reply to Thread

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