Why can't I get the Conditional Sum Wizard to work? Here is my formula:

[Darren D.]

Hey everybody,
I'm probably missing something obvious, but please help me if you can.
Here is my formula and now it just results in an empty cell. It won't
produce a result.
THANKS IN ADVANCE.
=SUM(IF($C$73:$C$77="Large-Cap/Growth",IF($C$73:$C$77="Large-Cap/Value",IF($C$73:$C$77="Small/Mid-Cap/Growth",IF($C$73:$C$77="Small/Mid-Cap/Value",$D$73:$D$77,0),0),0),0))

Originally I was trying to sum a table and have the answer appear on a
different worksheet and I kept getting a Runtime error 1004: unable to
get the formula array property of the Range class.

My table looked like this:

Large-Cap/Growth $500,000
Large-Cap/Value $750,000
Small/Mid-Cap/Growth $300,000
Small/Mid-Cap/Value $490,000
International $800,000
Fixed Income $700,000
Alternative Invest. $500,000
Cash & Equivalents $300,000

 

[Bob Umlas]

Your formula asks if C73:C77 is x, then if C73:C77 is y, then... but already
it's clearly false. Try this:
=SUMIF($C$73:$C$77,"Large-Cap/Growth",D7377)+SUMIF($C$73:$C$77,"Large-Cap/
Value",D7377)+SUMIF($C$73:$C$77,"Small/Mid-Cap/Growth",D7377)+SUMIF($C$7
3:$C$77,"Small/Mid-Cap/Value",D7377)