Results 1 to 9 of 9

COUNTIF Counting for Only One Occurrence in Two Columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-25-2013
    Location
    Virginia, USA
    MS-Off Ver
    Microsoft 365 Version 2409 64-bit
    Posts
    253

    COUNTIF Counting for Only One Occurrence in Two Columns

    I have three columns (A,B,C) and four rows (1,2,3,4). In column “A” the value “100” is entered in all four rows. In column “B” the values are “ACC”, “SEC”, “AAC”, & “AAC”. In column “C” the values are “AAC”, “AAC”, “SEC”, & “AAC”.

    I'm looking for a formula that counts the number of times the following conditions occur: the value "100" in column A and "AAC" in either column "B" or column "C". So, in the example the there are four occurrences where there is a "100" in column "A" and an "AAC" in column "B" or "C". What formula will give me the value "4"?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting past occurrence given a classification
    By makae90 in forum Excel General
    Replies: 7
    Last Post: 09-29-2017, 01:49 PM
  2. IF Statement / Occurrence counting
    By DHarper in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-29-2013, 10:49 AM
  3. Replies: 2
    Last Post: 04-18-2013, 02:03 PM
  4. Excel 2007 : Counting Occurrence of value across workbooks
    By jonwickert in forum Excel General
    Replies: 0
    Last Post: 05-03-2012, 10:47 AM
  5. Replies: 2
    Last Post: 02-23-2010, 03:01 AM
  6. Replies: 4
    Last Post: 09-24-2009, 09:57 AM
  7. Replies: 3
    Last Post: 08-20-2009, 06:08 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