+ Reply to Thread
Results 1 to 4 of 4

Count values with conditions

  1. #1
    Forum Contributor
    Join Date
    06-05-2014
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    145

    Count values with conditions

    Hi Team,

    i have two sheets and sheet 1 has project details like different project Ids, names of people assignet to each project, rate of each person, location of each person etc.

    i am trying to find the count of people with conditions.

    eg: i would like to know how many people are assigned under the project "1111" whose location is "Onshore" at the same time the rate is "50".

    The sheet 2 contains the template where the count has to be updated.

    Please see the attachement.

    Please help
    Attached Files Attached Files

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

    Re: Count values with conditions

    Using your posted workbook...this regular formula, copied down, returns the counts:
    Please Login or Register  to view this content.
    You might want to convert your sheet1 list to an Excel Table (Home.Format-as-table...follow the prompts)
    Then your formula would be more intuitive and descriptive:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    06-17-2014
    Location
    Uppsala, Sweden
    MS-Off Ver
    2010
    Posts
    43

    Re: Count values with conditions

    You could add filters, Data-Filters or probably use the formula COUNTIFS, I have to go now but I can take a look later/tomorrow if you didn't solve it.

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Count values with conditions

    G2:

    =SUMPRODUCT((Sheet1!$A$2:$A$19=A2)*(Sheet1!$F$2:$F$19=B2)*(Sheet1!$G$2:$G$19=C2))

    and copy down
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ 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] Count values with conditions
    By bigband1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2014, 11:49 AM
  2. [SOLVED] How to count cell values based on 2 conditions
    By ciw916 in forum Excel General
    Replies: 3
    Last Post: 11-20-2012, 05:58 PM
  3. [SOLVED] RE: Count values with conditions
    By Muhammed Rafeek M in forum Excel General
    Replies: 0
    Last Post: 08-21-2006, 06:05 AM
  4. [SOLVED] RE: Count values with conditions
    By Toppers in forum Excel General
    Replies: 1
    Last Post: 08-21-2006, 06:05 AM
  5. Re: Count values with conditions
    By Bob Phillips in forum Excel General
    Replies: 0
    Last Post: 08-21-2006, 06:05 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