Sumproducct question
There is probably a better awnser, but if it were only a few letters,
possible you could probalby use CHAR(x) in your IF formula. CHAR(77) =
capital M, whild CHAR(109), returns a small m. Also not sure if it can
compare that in a formula to what is in colm E.
--Decimal
"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
|