| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproducct question
=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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| UDF question | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
| IF Question | Excel Worksheet Functions | |||
Threaded Mode
