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

  • Thread starter Thread starter Darren D.
  • Start date Start date
D

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
 
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",D73:D77)+SUMIF($C$73:$C$77,"Large-Cap/
Value",D73:D77)+SUMIF($C$73:$C$77,"Small/Mid-Cap/Growth",D73:D77)+SUMIF($C$7
3:$C$77,"Small/Mid-Cap/Value",D73:D77)
 
Back
Top