. . . "How do I write a nested COUNTIF formula ( assigning a value of 1 for each cell) for a range of cells that does NOT contain , OFF, or REQ OFF ?For example:A row of 20 cells (A1:A20), 5 are blank (), 3 contain the text OFF, 4 contain the text REQ OFF, and the rest contain anything other than the three values just mentioned.I need a sum number for all the cells in that row that contain an" .