+ Reply to Thread
Results 1 to 4 of 4

COUNTIFS For Previous 7 Days

  1. #1
    Registered User
    Join Date
    08-31-2020
    Location
    USA
    MS-Off Ver
    365 Web
    Posts
    2

    COUNTIFS For Previous 7 Days

    Hello,
    I've tried several formulas and I can't seem to get this to work the way I am needing it to. I have a sheet that I want to sum the number of occurences of specific text that also contains text from a second column. I have a function that works for this. What I can't figure out is how to only show the occurrences from the last 7 days or s specific date range.

    This is the formula for the first part of my problem that works.
    =COUNTIFS('Sheet1'!A:A,"Alpha",'Sheet1'!D:D,"Revisit")

    This is what I thought would work but it doesn't
    =COUNTIFS('Sheet1'!A:A,"Alpha",'Sheet1'!D:D,"Revisit",'Sheet1'!B:B,"<="&TODAY()-7))

    Note, I am restricted to using Excel 365 Web so any workflows must work there.
    Spreadsheet attached. Thanks ahead of time for the help!
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,452

    Re: COUNTIFS For Previous 7 Days

    Do you means " > = " (instead of " < = ")?

    =COUNTIFS(Sheet1!A:A,"Alpha",Sheet1!D:D,"Revisit",Sheet1!B:B," > = "&TODAY()-7)
    Quang PT

  3. #3
    Registered User
    Join Date
    08-31-2020
    Location
    USA
    MS-Off Ver
    365 Web
    Posts
    2

    Re: COUNTIFS For Previous 7 Days

    Tried that and the formula is still broken.

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,452

    Re: COUNTIFS For Previous 7 Days

    Please point out the error in file and type some mock up results.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Average and Standard over the last 344 days excluding the previous 7 days
    By Renegade115 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-01-2018, 09:16 PM
  2. Replies: 13
    Last Post: 09-22-2016, 09:18 AM
  3. Countifs Help for Rolling 91 days
    By Seachelle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-22-2015, 08:02 PM
  4. Asking for previous date plus two days
    By KJBrown in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-21-2014, 10:02 AM
  5. Count Previous 30 days
    By Mattias1 in forum Excel General
    Replies: 10
    Last Post: 08-21-2011, 04:38 PM
  6. previous days in a formula
    By Useless_w/_excel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2008, 12:30 AM
  7. 25 days previous to today?
    By MaQ in forum Excel General
    Replies: 5
    Last Post: 03-14-2006, 03:00 PM

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