+ Reply to Thread
Results 1 to 2 of 2

COUNTIFS Across Columns

  1. #1
    Registered User
    Join Date
    10-01-2015
    Location
    Cape Town
    MS-Off Ver
    2013
    Posts
    2

    COUNTIFS Across Columns

    Hi Excel Gurus

    I need some help in constructing a Countifs formula.
    The result needs to take into consideration 2 criteria. I.e Which Company, and which Process

    How many Activities of the selected Process, of the selected Company is done by "X"
    How many Activities of the selected Process, of the selected Company is done by "Y"
    How many Activities of the selected Process, of the selected Company is done by "blank"


    I want to select a Company, and a Process

    I Attached my Sheet

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: COUNTIFS Across Columns

    Hi,
    =SUMPRODUCT(($A$2:$A$30=$L$12)*($B$2:$B$30=$L$11)*($C$1:$I$1=$L$13)*($C$2:$I$30=L15))

    where $L$12 is PROCESS name
    where $L$11 is ACTIVITY
    where $L$13 is COMPANY
    where $L$15 is X or Y
    for counting blank =SUMPRODUCT(($A$2:$A$30=$L$12)*($B$2:$B$30=$L$11)*($C$1:$I$1=$L$13)*($C$2:$I$30=""))

+ 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. [SOLVED] Countifs through 55 columns
    By manofcheese in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-20-2015, 03:45 PM
  2. SUM COUNTIFS across columns within a table and across tables...
    By scottmail in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 03-22-2015, 10:47 PM
  3. COUNTIFS help with conditional formatting for columns
    By ace10mccloud in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2014, 12:25 PM
  4. countifs - four columns
    By dulitul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-15-2013, 01:25 PM
  5. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  6. Using COUNTIFS with multiple columns
    By djsquare in forum Excel General
    Replies: 1
    Last Post: 06-27-2011, 01:58 PM
  7. Countifs and multiple columns...
    By ajayb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-09-2006, 10:35 AM

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