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.
Bookmarks