+ Reply to Thread
Results 1 to 8 of 8

Using MONTH() formula's to count data?

  1. #1
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Using MONTH() formula's to count data?

    See Attached Doc.

    If you look on Rolled up Figures tab i need to count data from the Customer complaints tab but for each individual month.

    So 1st row - Number of all complaints closed i need a formula so it only counts the complaints closed in January. If you look on the customer complaints tab the answer would be 3. Then i want to do the same formula for February and this time the answer should be 6.

    I think i need to incorporate MONTH() formula into it, but do not know where to start.

    Thanks for your help!!!
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Using MONTH() formula's to count data?

    Look example:
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Re: Using MONTH() formula's to count data?

    Thanks very much.....That works well!!!

    I have added another row on to the rolled up data to count money, but the formula i am using is showing a value error.

    Any suggestions?!
    Attached Files Attached Files

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Using MONTH() formula's to count data?

    Just remove SUM() from last part of formula:

    =SUMPRODUCT(--(MONTH('Customer Complaints'!$B$5:$B$1000)=MONTH('Rolled up Figures'!D$7)),'Customer Complaints'!$I$5:$I$1000)

  5. #5
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Re: Using MONTH() formula's to count data?

    Thanks again, for the future incase i want to add an average row too would it just be as simple as changing SUMPRODUCT to AVERAGEPRODUCT?!?

    tHANKS again!!!

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Using MONTH() formula's to count data?

    That would be nice

    Unfortunally you'll need SUM/COUNT


    =SUMPRODUCT(--(MONTH('Customer Complaints'!$B$5:$B$1000)=MONTH('Rolled up Figures'!D$7)),'Customer Complaints'!$I$5:$I$1000) / SUMPRODUCT(--(MONTH('Customer Complaints'!$B$5:$B$1000)=MONTH('Rolled up Figures'!D$7)))
    Last edited by zbor; 03-25-2010 at 10:20 AM.

  7. #7
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Re: Using MONTH() formula's to count data?

    Unfortunatly when i try and enter this it keeps coming up with an error......Missing a parenthesis?!?

  8. #8
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Using MONTH() formula's to count data?

    Try now...

+ 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