+ Reply to Thread
Results 1 to 2 of 2

Count Weekday but filter by 2 criteria

  1. #1
    Registered User
    Join Date
    11-20-2015
    Location
    edmoton
    MS-Off Ver
    2011
    Posts
    1

    Count Weekday but filter by 2 criteria

    Hello,

    I wasn't able to find a solution to my issue on any forum. I am looking to return the count of shipments that went out on a Monday and meet two criteria.

    =SUMPRODUCT(--(WEEKDAY(Table1[[Date Order Entered ]],2)=1)*1,(Table1[Detail Branch]=$C$6)*1,(Table1[Order Prep. Status]=$G6)*1)/COUNTIFS(Table1[Detail Branch],$C$6,Table1[Order Prep. Status],$G6)

    but it gave me a percent and I want the absolute number.

    Thanks,
    pb

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Count Weekday but filter by 2 criteria

    If you want the count...does this work for you?
    Please Login or Register  to view this content.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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. Filter for Last Weekday
    By dcoley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-26-2013, 06:03 PM
  2. [SOLVED] Need help in Weekday count formula
    By Manish_Gupta in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-27-2013, 03:15 AM
  3. [SOLVED] Using WEEKDAY() as a criteria in AVERAGEIFS()
    By carwashguy in forum Excel General
    Replies: 6
    Last Post: 09-25-2013, 02:57 PM
  4. Date to weekday count issue
    By DeepBlueSea in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2013, 10:04 PM
  5. auto filter criteria count
    By crazyqq in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2011, 10:38 AM
  6. count records which meet filter criteria
    By AKH in forum Excel General
    Replies: 1
    Last Post: 10-31-2005, 12:05 PM
  7. Function to count Number of weekday in a Month
    By thuanpham in forum Excel General
    Replies: 4
    Last Post: 05-21-2005, 09:19 AM

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