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

Sumproduct with 2 criteria.
 

=SUMPRODUCT((MONTH('Raw Data 2008'!A2:A1528)=1)*('Raw Data
2008'!B2:B1528<"XIAPPLXRP110")*('Raw Data 2008'!B2:B1528<"New Website"))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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

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

Sumproduct with 2 criteria.
 

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?

"Bernard Liengme" wrote:

=SUMPRODUCT((MONTH('Raw Data 2008'!A2:A1528)=1)*('Raw Data
2008'!B2:B1528<"XIAPPLXRP110")*('Raw Data 2008'!B2:B1528<"New Website"))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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

Sumproduct with 2 criteria.
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Amber" wrote in message
...
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?

"Bernard Liengme" wrote:

=SUMPRODUCT((MONTH('Raw Data 2008'!A2:A1528)=1)*('Raw Data
2008'!B2:B1528<"XIAPPLXRP110")*('Raw Data 2008'!B2:B1528<"New
Website"))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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