how do I set something NOT EQUAL
Posted by Joseph G. on May 23, 2001 8:01 AM
I am using an array function:
=SUM(IF(Master!$AR$3:$AR$159="technology",IF(Master!$AU$3:$AU$159="S",Master!$G$3:$G$159)))
what do I put in place of the equal sign between 159 and technology in order to say DOES NOT EQUAL technology, so as to include everything in that column except technology?
-Joseph A.
Posted by cpod on May 23, 2001 8:36 AM
=SUM(IF(Master!$AR$3:$AR$159<>"technology",IF(Master!$AU$3:$AU$159="S",Master!$G$3:$G$159)))
Posted by Aladin Akyurek on May 23, 2001 8:38 AM
Joseph
You can rewrite this array formula as follows:
=SUM((Master!$AR$3:$AR$159<>"technology")*(Master!$AU$3:$AU$159="S")*(Master!$G$3:$G$159))
I'd suggest a further improvement:
Select the cells $AR$3:$AR$159 on Master and give it a meaningful name via the Name Box or the option Insert|Name|Define. Do the same involving the range $AU$3:$AU$159 and $G$3:$G$159 on Master.
Then substitute these meaningful names in the revised formula. You can even replace this array formula by ordinary formulas if you so desire.
Aladin
