In the formula below I'm trying to count all the fields on the Master Spreadsheet in a workbook that contain "LD&E" in Column A2:A1199 and "O4" in column x2:x1199 and this portion works. However, I don't want to count "G" in z2:z1199 and the formula does not come up with the correct number. Please assist. thx


=COUNTIFS(MASTER!$A$2:$A$1199,"LD&E", MASTER!$X$2:$X$1199,"=O4")-SUM(COUNTIF(MASTER!$Z$2:$Z$1199,{"G"}))