=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)

wrote in message
...
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),GrossMar gin!BF$29:BF$89,0))}


Thanks,

Sherry