+ Reply to Thread
Results 1 to 2 of 2

function to find out count based on criteria.

  1. 05-30-2011, 06:37 AM #1
    arnab0711 is offline
    Forum Contributor
    Join Date
    02-11-2008
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    242

    function to find out count based on criteria.

    Hi,
    I have this table array,I want to find out how many vendors meets 4 out of 8 criterias given in the table.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-30-2011, 06:45 AM #2
    zbor is online now
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,031

    Re: function to find out count based on criteria.

    Insert row below names and then: COUNTIF(C4:C11, "y") and then you'll get how many y's per vendor.

    Then you can =COUNTIF(C3:BF3,">=4") to get your number
    Never use Merged Cells in Excel
    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)

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