Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Financial year calculation

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There is probably a simple formula for this that I can't work out, but here it goes.

    Lets say I have a worksheet with (as an example) Column A containing a list of dates spanning 3 years.(generally weekly dates)
    Column B contains dollar amounts for each date listed.

    What I want to do is have column C providing me with a calculation for the TOTAL dollar amount for each financial year. Of course, if it was per calandar year it would be simple to use the year function, but how do I do it based on financial year??

    I look forward to being proven a simpleton on this... in other words, I would love an answer.

    Raa

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This would all depend on the date ranges you have and how the business entity in question defines their fiscal year. Please let us know what these variables are.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    YOur problem can be solve by using pivotal table and then grouping on year.
    I advise you to use pivotal table and take on line wizard help in forming pivotal table.

    ni****h desai
    http://www.pexcel.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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