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

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
 
J

J.E. McGimpsey

I can't tell exactly what you're looking for, but IF() functions
have three arguments:

=IF(<condition>,<true branch>,<false branch>)

In your formula, If the values in C73:C77 = "Large-Cap/Growth", the
function proceeds to the "true branch", where it compares C73:C77 to
"Large-Cap/Value". This will *always* be false - if it's LC/G, it
can't be LC/V.
 
Top