+ Reply to Thread
Results 1 to 7 of 7

adding a Frequency function to a CountIFS function

  1. 03-10-2017, 01:16 PM #1
    Plucky_
    Plucky_ is offline
    Registered User
    Join Date
    03-10-2017
    Location
    London
    MS-Off Ver
    15.32
    Posts
    8

    adding a Frequency function to a CountIFS function

    Hi

    Is it possible to include a frequency function to a COUNTIFS function?

    Im trying to count how many deliveries a driver has made in a day by using a sheet that contains multiple jobs with information such as site delivered to.
    The problem I have is my COUNTIFS is counting all jobs that have been delivered by a driver on a particular day even if they have all gone to the same customers address.
    I need it to include a frequency function on column D to just count the individual customers sites he delivers too.

    =COUNTIFS(ACOL_All!F:F,71003,ACOL_All!J:J,$B6)

    F column is the drivers ID "71003"
    J column is the Delivery Date ( B6 is the Date )
    D column is the Customers ID

    any help would be much appreciated.
    Reply With QuoteRegister To Reply
  2. 03-10-2017, 04:08 PM #2
    mcmahobt
    mcmahobt is offline
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: adding a Frequency function to a CountIFS function

    Can you upload a sample workbook?
    Spread the love, add to the Rep

    "None of us are as smart as all of us."
    Reply With QuoteRegister To Reply
  3. 03-10-2017, 04:27 PM #3
    Plucky_
    Plucky_ is offline
    Registered User
    Join Date
    03-10-2017
    Location
    London
    MS-Off Ver
    15.32
    Posts
    8

    Re: adding a Frequency function to a CountIFS function

    Hi mcmahobt

    Ive entered the values I need manually in red on Sheet2.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-10-2017, 05:35 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: adding a Frequency function to a CountIFS function

    Edited Formula.

    Hi Plucky_. Welcome to the forum.

    I don't think COUNTIFS is the function of choice here.

    With the understanding that 'Item No' is in cell D1 and is referenced rather than hard coded into the formula:

    Try this array entered formula and fill down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by FlameRetired; 03-10-2017 at 05:39 PM.
    Dave
    Reply With QuoteRegister To Reply
  5. 03-10-2017, 07:25 PM #5
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: adding a Frequency function to a CountIFS function

    The array formula can be simpler still
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 03-11-2017, 12:26 AM #6
    Plucky_
    Plucky_ is offline
    Registered User
    Join Date
    03-10-2017
    Location
    London
    MS-Off Ver
    15.32
    Posts
    8

    Re: adding a Frequency function to a CountIFS function

    Brilliant, Thats perfect.

    Thanks for your help.
    Reply With QuoteRegister To Reply
  7. 03-12-2017, 08:13 PM #7
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: adding a Frequency function to a CountIFS function

    You're welcome. Glad to help, and thanks for the feedback.
    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)

Similar Threads

  1. COUNTIFS function makes excel slow, how to make the function "shorter"
    By Gifupack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2015, 07:01 AM
  2. COUNTIF/COUNTIFS function + nested user-defined function
    By shamjamali in forum Excel General
    Replies: 1
    Last Post: 05-12-2015, 09:12 PM
  3. Use COUNTIFS function on results of DATEVALUE function?
    By Si902 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-16-2015, 08:13 PM
  4. [SOLVED] Frequency Function
    By TPAge1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2014, 02:31 PM
  5. Excel 2007 : help with a FREQUENCY function
    By jenya_utd in forum Excel General
    Replies: 5
    Last Post: 02-06-2012, 07:52 AM
  6. Frequency Function
    By stoudimaire in forum Excel General
    Replies: 7
    Last Post: 09-23-2009, 01:58 PM
  7. [SOLVED] Frequency function
    By Pritesh in forum Excel General
    Replies: 2
    Last Post: 04-18-2005, 05:06 PM

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