IF OR AND
Try this. Normally entered:
=SUMPRODUCT(--($J2:$J20000="to"),--(($L2:$L20000=$B2)+($N2:$N20000=$B2)0),$AV2:$AV20 000)
--
Biff
Microsoft Excel MVP
"bob" wrote in message
...
If $J2:$J20000 = "to" and $L2:$L20000 or $N2:$N20000 = $B2, then I want
to
SUM $AV2:$AV20000
Can anyone kindly help me with an array formula for this? Thank you.
Bob
|