View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MESTRELLA29[_2_] MESTRELLA29[_2_] is offline
external usenet poster
 
Posts: 34
Default Sumproduct Questions

=(SUMPRODUCT((A!$D$2:$D$10000="B")*(A!$F$2:$F$1000 0=INDIRECT(A4))*(LEFT(A!$G$2:$G$10000,4)="3907")*( A!$J$2:$J$10000)))

is it posible to put Or condition to this formula,

I need to pick Up "b" ,"c", "s" From My data base.
(A!$D$2:$D$10000="B")+(A!$D$2:$D$10000="C")+(A!$D$ 2:$D$10000="S")

Thanks for your help