+ Reply to Thread
Results 1 to 4 of 4

Counting items based on criteria located in two columns

  1. #1
    Registered User
    Join Date
    02-10-2021
    Location
    Bogotá. Colombia
    MS-Off Ver
    2013
    Posts
    11

    Counting items based on criteria located in two columns

    Dear Best regards

    I wanted to ask you if there is a way to perform a count by applying formulas directly, without having to resort to the filter option, through the COUNTIF or COUNTIFS function.

    From two criteria found in column A ("ENROLLED"; "ENROLLED -ACADEMICALLY COMPLETED"), I would like to know how many of them meet the "Paid" criteria found in Column C

    Example.png

    I appreciate your collaboration

    Psdt: I am using Office 365 version

    I attach the book in case you want to know the detailed data in the image.
    Attached Files Attached Files
    Last edited by ferfer20; 07-22-2021 at 12:56 PM. Reason: SOLVED

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,246

    Re: Counting items based on criteria located in two columns

    You can simplify the formula you have in E2 by using wildcards, like this:

    =COUNTIFS(A:A,"ENROLLED*")

    where the asterisk is the wildcard character meaning "any number of other characters (including none)".

    Strictly speaking, you don't need to use COUNTIFS in that particular case, but it makes it easy to incorporate other conditions, like this:

    =COUNTIFS(A:A,"ENROLLED*",C:C,"Paid")

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    02-10-2021
    Location
    Bogotá. Colombia
    MS-Off Ver
    2013
    Posts
    11

    Re: Counting items based on criteria located in two columns

    Dear @Pete_UK thank you very much for your valuable information, it turned out to be quite useful. A big hug!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,246

    Re: Counting items based on criteria located in two columns

    Glad to have helped - thanks for the rep.

    Pete

+ 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] Counting Columns Based on Criteria
    By VirginiaABC in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-26-2020, 07:48 AM
  2. HELP! Counting number of items based on criteria and date
    By shredraldz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-04-2019, 08:36 PM
  3. [SOLVED] Counting cells based on criteria in 2 columns
    By cathb23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 05:07 PM
  4. [SOLVED] Counting number of items based on two columns
    By lukka in forum Excel General
    Replies: 3
    Last Post: 04-18-2012, 05:14 AM
  5. Counting items using criteria from 3 columns
    By gizzard in forum Excel General
    Replies: 5
    Last Post: 06-10-2011, 07:11 PM
  6. Replies: 1
    Last Post: 08-02-2006, 12:15 PM
  7. Help w/ counting multiple columns based on IF criteria
    By ConstructionGuy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2005, 12:10 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