Thread: how to OR() to a SUMPRODUCT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
  
Posts: 383
Default how to OR() to a SUMPRODUCT
hi, trying to test 2 colums, of 1 column: has either of 2 criteria..

=SUMPRODUCT(--(AQ233:AQ2000=AQ232),OR(--(AA233:AA2000="p0"),--(AA233:AA2000="p1"))) not quite working

singularly, does work: (but need to test for "p0" or "p1"), thanks
- how to OR() a sumproduct..

=SUMPRODUCT(--(AQ233:AQ2000=AQ232),--(AA233:AA2000="p0"))0

Reply With QuoteReply With Quote