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.

Please Login or Register  to view this content.

Sample is attached to this post, thank you for any help.

Another way:

Formula:

Please Login or Register  to view this content.

You are Welcome! Thanks for the feedback and rep . Glad to have helped.