It appears columns AT5:AY5 already do the job of counting what you want included. Each cell counts only "R" (AT5), "TD" (AU5), "BU" (AV5), "TC" (AW5), "F" (AX5) and "M" (AY5).
Could we simplify the whole process and just check to see if "P" is present in the range, then sum only THOSE columns? Since they are the only ones that count against the engine maintenance flow days?
If "P" ISN'T in the range (N5:AR5) then BA5=0.
If "P" IS in the range, then BA5 = sum AT5:AY5, and add L5 to it as in the formula below:
There's no need to re-count all of the entries if they are already totaled in other cells.
-Vince
Bookmarks