+ Reply to Thread
Results 1 to 3 of 3

Countif or sumproduct for current week

  1. 05-13-2013, 02:17 PM #1
    acecalder
    acecalder is offline
    Registered User
    Join Date
    04-08-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    8

    Countif or sumproduct for current week

    I am struggling with the total sales during a current week. Month are working fine. Ant help is appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-13-2013, 02:36 PM #2
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Countif or sumproduct for current week

    Assuming you are counting Monday to Sunday try this formula

    =COUNTIFS(E:E,">="&TODAY()-WEEKDAY(TODAY(),3),E:E,"<"&TODAY()-WEEKDAY(TODAY(),3)+7)
    Audere est facere
    Reply With QuoteRegister To Reply
  3. 05-13-2013, 02:40 PM #3
    acecalder
    acecalder is offline
    Registered User
    Join Date
    04-08-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Countif or sumproduct for current week

    daddy, this works very well. Thanks very much.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1