Results 1 to 4 of 4

Countif multiple column conditions

Threaded View

  1. #1
    Registered User
    Join Date
    12-28-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    72

    Countif multiple column conditions

    Because of a very complex model I'll simplify the precise need in the following example.
    I need to count entries on multiple conditions.
    I appreciate that i could add multiple countif conditions, but for the full data set, this is not practical. Also being restricted to nominating the row numbers is not ideal (ie not being able to leave the entire column referenced "C:C" fashion)

    Is there a more elegant way to achieve this?

    Does the answer lie in the Sumproduct function
    ???


    this stripped down example, how can i count the weekend shifts of each staff member by member and day. Ideally I need to add two more criteria permutation options (eg Staff member, Sat/Sun, Overtime Y/N, Shift A B or C)
    Thanks as always
    Attached Files Attached Files
    Last edited by _MANNY_; 08-31-2018 at 08:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. countif with multiple conditions
    By vancoservices in forum Excel General
    Replies: 12
    Last Post: 06-16-2010, 04:16 PM
  2. Countif multiple conditions
    By Carlos_82 in forum Excel General
    Replies: 9
    Last Post: 11-16-2008, 03:23 PM
  3. Multiple conditions on a countif
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 11:05 AM
  4. Multiple conditions on a countif
    By Mr Mike in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Multiple conditions on a countif
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  6. Multiple conditions on a countif
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 04:05 AM
  7. Multiple conditions on a countif
    By Mr Mike in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. Countif w/ multiple conditions
    By mjack003 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-30-2005, 08:13 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1