Thread: IF OR AND
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
  
Posts: 972
Default IF OR AND
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
Reply With QuoteReply With Quote