I am trying to write a Countif formula that reads as follows =COUNTIFS(Data!C:C,"Heart Center",Data!A:A,">06/30/2017",Data!A:A,"<08/01/2017",Data!D:D,">3000",Data!D:D,"<3999") but I now need to incorporate into the formula where it would only count if the entire row is populated, columns E-K could potentially be blank, if ones blank they'd all be blank and shouldn't be counted.