Sumproduct with 2 criteria.

A

Amber

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
 
B

Bernard Liengme

=SUMPRODUCT((MONTH('Raw Data 2008'!A2:A1528)=1)*('Raw Data
2008'!B2:B1528<>"XIAPPLXRP110")*('Raw Data 2008'!B2:B1528<>"New Website"))
best wishes
 
P

PCLIVE

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
 
A

Amber

Can I use the same information for a COUNTIF Statement?

=COUNTIF('Raw Data 2008'!B2:B64778,"<>XIAPPLXRP110")

=COUNTIF('Raw Data 2008'!B2:B64778,("<>XIAPPLXRP110"+"<>NEW WEBSITE))

Or is this even possible with a COUNTIF statement?
 
B

Bernard Liengme

No, COUNTIF take only one criteria (XL2007 has SUMIFS and COUNTIFS for more
than one condition)
SUMPRODUCT can do all that COUNTIF can and more in XL2003
best wishes
 
Top