+ Reply to Thread
Results 1 to 4 of 4

sum values for a financial year

  1. #1
    Registered User
    Join Date
    05-25-2010
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    2

    sum values for a financial year

    Hi all,

    I have a set of about 60 month-end dates (60 months, 5 years), not necessarily starting at the beginning of a financial year (1 apr to 31 mar)....say from A1 to A60... I would like to sum all values in the array range B1 to B60...for the same financial year...such that each cell below a particular date (in row C) should show the sum of values in the financial year it falls in.

    Pls help if you have any ideas.

    Thanks,
    Abhishek

  2. #2
    Registered User
    Join Date
    03-15-2007
    Posts
    62

    Re: sum values for a financial year

    I hope this attached file will help you

    Chadrashekhar
    Attached Files Attached Files
    Last edited by teylyn; 05-25-2010 at 07:47 AM. Reason: removed quote

  3. #3
    Registered User
    Join Date
    05-25-2010
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: sum values for a financial year

    Thank You Chandrashekhar. I think this should do. Also, thank you very much for your efforts in putting it in excel.

    Abhishek
    Last edited by teylyn; 05-25-2010 at 07:47 AM. Reason: removed quote

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: sum values for a financial year

    Can you both please stop quoting whole posts? It adds no value and just creates clutter.

+ 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