If I use this staement it counts for this year. How do I count for Jan 2007? Thanks Sharon
S s2m via OfficeKB.com Aug 24, 2006 #1 If I use this staement it counts for this year. How do I count for Jan 2007? Thanks Sharon
T Toppers Aug 24, 2006 #2 Assuming this is with SUMPRODUCT ..... --(MONTH(Odyssey!$AJ$2:$AJ$999)=1)),--(YEAR(Odyssey!$AJ$2:$AJ$999)=2007) HTH
Assuming this is with SUMPRODUCT ..... --(MONTH(Odyssey!$AJ$2:$AJ$999)=1)),--(YEAR(Odyssey!$AJ$2:$AJ$999)=2007) HTH
B Bob Phillips Aug 24, 2006 #3 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)
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)
