Results 1 to 5 of 5

countif if one of two column have value "LATE"

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-27-2022
    Location
    MS, USA
    MS-Off Ver
    Microsoft 365
    Posts
    149

    countif if one of two column have value "LATE"

    Hi,

    I have a table (tbl_TrackingLog) with two columns [STCM ON TIME/LATE] and [LTCM ON TIME]. I am trying to get a total of "LATE" items in cell U2 for these two columns. BUT the problem I am running into is if row 13 has "LATE" in column [STCM ON TIME/LATE] and [LTCM ON TIME], I do not want it to count it twice, but only once. As in real life usage, the row is regarding one document and it can't be "LATE" twice. Its either on time or late.

    The results I want would imitate this, but for the sum of the whole table and not just a row.
    =IF(V13="LATE",COUNTIF(V13,"LATE"),COUNTIF(AE13,"LATE"))

    Sample is attached to this post, thank you for any help.
    Attached Files Attached Files
    Last edited by Ajaxs87; 01-13-2024 at 11:55 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. countif to return "x" for unique & "xx" for duplicate values in a column
    By Shruder in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2018, 05:31 PM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  4. COUNTIF column if cell contains both "text1" and "text2"
    By Quuador in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-05-2012, 07:12 AM
  5. How do I compare two times to see if one is "late" or "on time"?
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2005, 06:05 PM
  6. [SOLVED] How do I compare two times to see if one is "late" or "on time"?
    By AuditorGirl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  7. [SOLVED] How do I compare two times to see if one is "late" or "on time"?
    By AuditorGirl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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