+ Reply to Thread
Results 1 to 12 of 12

count if date is this week

  1. #1
    Forum Contributor
    Join Date
    10-18-2012
    Location
    new york
    MS-Off Ver
    Excel 2013
    Posts
    152

    count if date is this week

    I need to write a formula which will count cells column T that say 'on time' but only if the date in column m is this week. I have got as far as =SUMPRODUCT !
    The date bit is where I'm struggling. Thank you x

  2. #2
    Forum Contributor
    Join Date
    11-05-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: count if date is this week

    Try Countifs.
    Add a column where you use the WEEKNUM() function to calculate the week number of the date in column M. Lets say you've used the column Z for this.
    Your formula would then be:
    =COUNTIFS(T:T,"On time",Z:Z,WEEKNUM(TODAY()))
    Taming the Excel dragon... www.TheExcelphile.com

  3. #3
    Registered User
    Join Date
    11-06-2012
    Location
    Bel Air, MD
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: count if date is this week

    I think is the right place within this forum to ask my question... I need a formula (I think COUNTIFS) that will count numbers that are equal to "1" but only if a specific word is listed in another column. For instance... If "Donkey" is listed in column "A" then I need the formula to count the number listed a corresponding column (could be "B") but only if it is equal or less than "1". I appreciate any help...

  4. #4
    Forum Contributor
    Join Date
    11-05-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: count if date is this week

    Crossfirepower, use the following formula:

    =COUNTIFS(A:A,"Donkey",B:B,"<=1")

    Don't forget to click on the little star on the left of this post if you feel I helped

  5. #5
    Registered User
    Join Date
    08-28-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: count if date is this week

    Hope this will be a simple way to solve this. pls find attachment.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-06-2012
    Location
    Bel Air, MD
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: count if date is this week

    Yes and no (this helped). I forgot to tell you that the information comes from the first worksheet "Billet Roster" and will fill a specific cell on the second worksheet.

    Would it then look like =COUNTIFS(!Monster Mash!A:A,"Donkey",!Monster Mash!B:B,"=<1")?

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,000

    Re: count if date is this week

    @crossfirepower

    Maybe you can try the formula and you will know.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  8. #8
    Registered User
    Join Date
    11-06-2012
    Location
    Bel Air, MD
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: count if date is this week

    I did and it didn't which is the reason why I'm asking for further instruction.

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,000

    Re: count if date is this week

    Then post an exampel of your Excel file without confidentional information

  10. #10
    Registered User
    Join Date
    11-06-2012
    Location
    Bel Air, MD
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: count if date is this week

    "Oeldere" if it were tha easy I would. Here is a sample of what I'm referring too(attached).Monster Mash (Sample).xlsx

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,000

    Re: count if date is this week

    I advice a pivot table.

    see the attached file.
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    11-05-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: count if date is this week

    If you do want to use a formula instead of a pivot table, use the following formula:

    =COUNTIFS('Monster Mash'!A:A,"Donkey",'Monster Mash'!D:D,"<=1")

+ 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