Sumproduct with 2 criteria.
You don't need to use OR.
=SUMPRODUCT(--(MONTH('Raw Data 2008'!A2:A1528)=1),--('Raw Data
2008'!B2:B1528<"XIAPPLXRP110"),--('Raw Data 2008'!B2:B1528<"New Website"))
HTH,
Paul
--
"Amber" wrote in message
...
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
|