+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Count If function for days/weeks in a given month

  1. #1
    Registered User
    Join Date
    01-07-2012
    Location
    Toledo, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    3

    Count If function for days/weeks in a given month

    Hello,

    I want to do a count if function for all 12 months, by month, between the four weeks in that month as part of a monthly roll up so I can roll up by year also. The program will not let me =SUM(all 52 weeks data). Anyone know how to do this because I am stumped!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Count If function for days/weeks in a given month

    Hi JMyers,

    Welcome to the forum.
    It seems to be achievable what you are asking for but for that forum need to understand the data spread, would you be able to upload a sample file for that. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    01-07-2012
    Location
    Toledo, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Count If function for days/weeks in a given month

    It looks like this, I need to count values in cell of plots containing their month. There are four different plots for each month that need to be counted up by month. All values must be in the correct cells, rows and columns.
    Attached Files Attached Files

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Count If function for days/weeks in a given month

    Hi JMyers,

    Thanks for the attachment.
    After opening it, I saw all blank cells with no data. Would suggest you to put through some example as well plus your desired results manually and I will be happy to obtain same using formulas.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    01-07-2012
    Location
    Toledo, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Count If function for days/weeks in a given month

    This should give a better idea of whats going on. Thanks for the help!
    Attached Files Attached Files

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Count If function for days/weeks in a given month

    Hi JMyers,

    Sorry to say, but it is still not very clear.
    I have checked the YTD Total section, and here the number are appearing similar to the numbers from below sections.
    I suggest you to calculate a number manually and put it in the respective cell, highlight it as Green background, now highlight the yellow cells using which that number is to be calculated using formulas. Also there are all "names" in the spreadsheet which should be name1, name2 etc.. if yes, correct this as well. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ 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