Hi all.

This is a re-post, in a sense, of a question I posted last week to this
forum.

I work at a college and use SUMPRODUCT formulas to total up all kinds of
stuff.  For example, to calculate the number of people majoring in a
particular area (in this case, Social Sciences and Arts), I use the
following:
=SUMPRODUCT(((Major="African/African Am Studies")+(Major="Ancient
History")+(Major="Art")+(Major="Art History")+(Major="Asian
Studies")+(Major="Chinese")+(Major="Classics")+(Major="Classical
Studies")+(Major="Communication Theory")+(Major="Comparative
Literature")+(Major="Drama")+(Major="Education")+(Major="English")+(Major="F
ilm Studies")+(Major="French")+(Major="Government")+(Major="Health
Policy")+(Major="History")+(Major="Humanities")+(Major="Human Development &
Education")+(...etc..)+(Major="Visual Studies")+(Major="War and Peace
Studies"))*((Decision="BA")+(Decision="BB")+(Decision="BC"))*(Round="1"))

Some of these formulas are getting too long for excel.  I posted asking if a
lookup function was the right way to fix it...  A reply suggested the
following:
=SUMPRODUCT(--(Major={"African/African Am Studies","Ancient
History","Art","Art History",etc...}))

Which works for counting the majors by themselves, but I can't seem to the
other conditions in (like DECISION and ROUND) using the same format.  I
tried something like this:
   =SUMPRODUCT(((--(Major={"Economics","Finance","Inter'l Economic
Policy","Monetary & Financial Policy","Public
Economics"}))*(--(Decision={"BA","BC"}))*(Round="1")))

But as soon as I combine two of the --(Major={ things, I get an #N/A error.

Any thoughts/help appreciated.

Best,  Dluxe