(MONTH(Odyssey!$AJ$2:$AJ$999)=8))
 

If I use this staement it counts for this year. How do I count for Jan 2007?

Thanks

Sharon

--
Message posted via http://www.officekb.com

(MONTH(Odyssey!$AJ$2:$AJ$999)=8))
 

Assuming this is with SUMPRODUCT .....

--(MONTH(Odyssey!$AJ$2:$AJ$999)=1)),--(YEAR(Odyssey!$AJ$2:$AJ$999)=2007)

HTH

"s2m via OfficeKB.com" wrote:

If I use this staement it counts for this year. How do I count for Jan 2007?

Thanks

Sharon

--
Message posted via http://www.officekb.com

(MONTH(Odyssey!$AJ$2:$AJ$999)=8))
 

or even

--(TEXT(Odyssey!$AJ$2:$AJ$999,"mmmyyyy")="Jan2007")

or

--(TEXT(Odyssey!$AJ$2:$AJ$999,"mmyy")="0107")



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Toppers" wrote in message
...
Assuming this is with SUMPRODUCT .....

--(MONTH(Odyssey!$AJ$2:$AJ$999)=1)),--(YEAR(Odyssey!$AJ$2:$AJ$999)=2007)

HTH

"s2m via OfficeKB.com" wrote:

If I use this staement it counts for this year. How do I count for Jan
2007?

Thanks

Sharon

--
Message posted via http://www.officekb.com