Excel Formula comparison (If~Then~AND~Else)

=IF(AND(E14="",D14<>""),"No Personal Miles","")

Excel Formula to count word instances in a column based on 2 different criteria

=SUMPRODUCT(('Raw Data Tab'!$K$2:$K$15=$A3)*('Raw Data Tab'!$L$2:$L$15=I$1))