+ Reply to Thread
Results 1 to 3 of 3

Report counted cells based on day and month of the year

  1. #1
    Registered User
    Join Date
    03-11-2010
    Location
    Bendigo, Australia
    MS-Off Ver
    Excel 2007
    Posts
    11

    Report counted cells based on day and month of the year

    Hi

    I have large pivot table which contains data i would like to summarize.

    In the attached you will see an extract from my pivot table on the left and the results i would like to achieve in the bold boxes on the right of the worksheet.

    The 03 and 04 in column A are the months of the year eg March and April.
    The 1, 2, 3 in cells C2, D2, E2 are the days of the week. These days go out to maximum 31 days.
    Column B are invoice numbers
    and column C,D,E,.. are the associated invoice $ value.

    What i would like to do is count how many invoice there were on each particular day of each month.
    For example on the 01/03/13 there were 7 invoice. 02/03/13 there were 9. 01/04/13 there were 9.

    The end report i would like the data in future months to show 0 or - and when the pivot table is refreshed in future and that information becomes avaliable i would like it to automatically appear in the report.

    I have found that using the count formula is easy enough but i can work out how to incorporate the month column into my formulas so that i can fill out my report and have it update as each month passes.

    Any help would be greatly appreciated. Let me know if my explanation of my problem needs further explanation.
    Attached Files Attached Files
    Last edited by Chanley24; 05-08-2013 at 09:15 PM. Reason: Better Thread Title

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,328

    Re: Count

    We would love to help you with your question, but 1st, in accordance with forum rule, please rename your thread to something more meaningful, that actually describes your problem.

    Because thread titles are used in searching the forum it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.

    Also, many members will look at a thread title, and if it is of interest to them, or it falls within their area of expertese, they might only open those threads.

    Look at it this way...if you typed that title into google, what would you expect to get back?
    To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-11-2010
    Location
    Bendigo, Australia
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Count

    Hi

    Sorry.

    I saw after i had originally posted my questions that i didn't complete the title.

    I didn't realize i could change it at the time.

    Now that i know i have fixed the problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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