Sumproducct question
Here is one solution (I am sure there will be a more elegant solution)...
Type or paste the following in a cell and then press CTRL-SHIFT-ENTER
=SUMPRODUCT(IF(E16:E200<"",IF(CODE(E16:E200)<COD E(UPPER(E16:E200)),N16:N200,0),0),--(M16:M200=""))
It will add up column N where Col E has a lower case letter and Col M is blank
"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
|