I am trying to edit this formula without the last entry =COUNTBLANK(I13:I18)+COUNTIF(I32:I35,"s")+COUNTIF(I13:I18,"d/s")+COUNTIF(I3:I18,"d/s") But it wouldn't retain my original formula. How do I remove the last entry {COUNTIF(I13:I18,"d/s")} and still maintain the formula? It counts the "d/s" twice. Any help would be great.