+ 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
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016
    Posts
    6,972

    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
    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)

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