=SUM(IF(rngE<"",IF((CODE(rngE)=97)*(CODE(rngE<=1 22))*(rngM=""),rngN)))


"DocBrown" wrote:

Can anyone help with a sumproduct question?

I would like to sum the values in range $N$16:$N$200 if the value in column
E of the row is not a capital letter and column M of the row is blank.

Column E can be blank, one uppercase letter, or lower case letter.

Thanks a bunch
John