+ Reply to Thread
Results 1 to 13 of 13

Formula to Calculate Quarter & Yearly Figures

Hybrid View

foxtrot1961 Formula to Calculate Quarter... 08-12-2013, 01:36 PM
Winon Re: Formula 08-12-2013, 01:54 PM
Fotis1991 Re: Formula 08-12-2013, 01:57 PM
Winon Re: Formula 08-12-2013, 02:05 PM
oeldere Re: Formula to calculate... 08-18-2013, 04:52 AM
oeldere Re: Formula to calculate... 08-18-2013, 05:00 AM
RobertMika Re: Formula to calculate... 08-18-2013, 05:25 AM
foxtrot1961 Re: Formula to calculate... 08-18-2013, 07:49 AM
RobertMika Re: Formula to calculate... 08-18-2013, 07:55 AM
foxtrot1961 Re: Formula to calculate... 08-18-2013, 08:07 AM
oeldere Re: Formula to calculate... 08-18-2013, 08:18 AM
foxtrot1961 Re: Formula to calculate... 08-18-2013, 10:20 AM
oeldere Re: Formula to calculate... 08-18-2013, 10:22 AM
  1. #1
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Formula to calculate monthly, quarterly and annual amounts - categorize

    So the data will change?
    Could you post esample of your desired outocome?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  2. #2
    Registered User
    Join Date
    07-25-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Formula to calculate monthly, quarterly and annual amounts - categorize

    The data will be captured daily per month. I want to group the data together as per my excel example attached per month per quarter per year. As soon as I can group the totals as per the example then I want to display the information as graphs on a plasma screen. My challenge is to calculate / group the totals as per the captured data. Help with the formulas will be appreciated, if someone can assist me with one then hopefully I will get the others to word.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 10-08-2009, 03:45 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