| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
(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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
(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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
(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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
