Closed Thread
Results 1 to 2 of 2

COUNTIFs key words

  1. #1
    Registered User
    Join Date
    07-15-2020
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    21

    COUNTIFs key words

    Hello

    I am trying to create a formula that counts the number of 'TRUE' cells in a particular column, based on certain criteria.

    Here, I have created some dummy portfolios. Each of the three individuals (Me, John, Simon) has a column that shows the number of breaches ('TRUE').

    In the table on the left (yellow highlight) I am trying to calculate how many 'TRUEs' there are in the column, between a certain time period (cells C5:C6).

    The idea would be that this table would update, whenever you change the dates. i.e. how many breaches in the last year, or last week, etc.


    I have attached the dummy excel file

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,443

    Re: COUNTIFs key words

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...key-words.html
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. COUNTIFs key words
    By JM45T3R5 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2020, 06:05 AM
  2. [SOLVED] exclude certain words from a COUNTIFS formula
    By R.Sloan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2017, 03:40 AM
  3. Issue with sumproduct/ countifs in regards finding certain words in date range
    By airedale360 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-25-2016, 08:02 PM
  4. [SOLVED] Countifs Function, Words in a cell Criteria
    By baca25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-29-2014, 04:50 AM
  5. [SOLVED] multiple words in my COUNTIFS formula
    By tlacloche in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2014, 01:42 PM
  6. Replies: 6
    Last Post: 02-21-2009, 08:13 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1