Results 1 to 2 of 2

Count the number cells > 0 for each day of the month.

Threaded View

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

    Count the number cells > 0 for each day of the month.

    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-20-2013 at 02:05 AM.

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