+ Reply to Thread
Results 1 to 3 of 3

Count Based on First Instance and Criteria

  1. 04-06-2021, 10:52 AM #1
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Count Based on First Instance and Criteria

    hi,

    I need a formula to count based on first appearance and criteria. I have attached a sample for more clarification.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-06-2021, 11:37 AM #2
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,583

    Re: Count Based on First Instance and Criteria

    Pl see file.
    ARRAY formula in K2
    Please Login or Register  to view this content.
    In I2
    Please Login or Register  to view this content.
    Both copied down.
    To enter ARRAY formula
    Copy and paste the formula in cell
    Press F2
    Press Ctrl+Shift+Enter together
    Excel covers the formula with {}.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  3. 04-06-2021, 12:05 PM #3
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Re: Count Based on First Instance and Criteria

    Thanks, but I need to include the count in Pivot Table. Need the formula in table so that when I refresh the pivot table it should reflect.
    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. Count Blank and count based on criteria only Formula Allowed
    By Harmender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2019, 12:26 PM
  2. Running count of value instance
    By jchrystal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2014, 10:32 AM
  3. [SOLVED] Count values in one list and then narrow/combine values based on criteria and count those
    By razz0807 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2014, 02:53 PM
  4. [SOLVED] Count in a range, where identical adjacent cells count as one instance.
    By the-algebraist in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-05-2013, 11:18 AM
  5. [SOLVED] Count based on certain criteria
    By hparnian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-14-2012, 03:25 AM
  6. Count instance where multiple matches can occur and with multiple criteria
    By herghost in forum Excel General
    Replies: 2
    Last Post: 09-16-2011, 07:45 AM
  7. [SOLVED] Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2006, 10:35 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