"OR" Function in an Array Formula

[2sherberts]

Hi,

Can someone tell me what is wrong with my formula? It seems that the
"OR" function in this formula is not working. It is bringing back a
zero when there should be a number.


{=SUM(IF((GrossMargin!$B$29:$B$89=Metrics!$B35)*($C35=GrossMargin!$C
$29:$C$89)+($D35=GrossMargin!$C$29:$C$89),GrossMargin!BF$29:BF$89,0))}


Thanks,

Sherry

 

[Bob Phillips]

=SUM(IF((GrossMargin!$B$29:$B$89=Metrics!$B35)*(($C35=GrossMargin!$C$29:$C$89)+($D35=GrossMargin!$C$29:$C$89)),GrossMargin!BF$29:BF$89,0))

shouldn't your tests against C35 and D35 also be testing in sheet Metrics?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[2sherberts]

Thank you for responding to my post. Both reply helped a lot!