View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amber Amber is offline
external usenet poster
 
Posts: 68
Default Sumproduct with 2 criteria.

Good Morning,

I have an expression =SUMPRODUCT((MONTH('Raw Data 2008'!A2:A1528)=1)*('Raw
Data 2008'!B2:B1528<"XIAPPLXRP110")) in which I would like to add another
criteria.

I would like to say not "XIAPPLXRP110" or "New Website"

I have never learned the way to say "or" in a formula.

Thanks, AP