Count occurance of months
in [General]
|
Prev: conditional formatting for more than 3 conditions
Next: Final Reminder - Microsoft Responds to the Evolution of Community
From: DaveC on 28 May 2010 12:00 Hi Folks, I am using the following formula to try to count how many cells contain a date within January but its not working for me =SUMPRODUCT((MONTH('Tracker 2010'!T6:T2643)=1)*('Tracker 2010'!T6:T2643<>" " )) Date format is 13/01/2010 in T6, 16/01/2010 in T7 and so on Any help you could give is appreciated Dave
From: BSc Chem Eng Rick on 28 May 2010 12:08 Try =SUMPRODUCT(--(MONTH('Tracker 2010'!T6:T2643)=1)) -- If this helps, please click "Yes" <><><><><><><><><><><> "DaveC" wrote: > Hi Folks, > > I am using the following formula to try to count how many cells contain a > date within January but its not working for me > > =SUMPRODUCT((MONTH('Tracker 2010'!T6:T2643)=1)*('Tracker 2010'!T6:T2643<>" " > )) > > Date format is 13/01/2010 in T6, 16/01/2010 in T7 and so on > > Any help you could give is appreciated > > Dave > > >
From: DaveC on 28 May 2010 12:12 Didn't work, got a #VALUE result "BSc Chem Eng Rick" wrote: > Try > =SUMPRODUCT(--(MONTH('Tracker 2010'!T6:T2643)=1)) > -- > If this helps, please click "Yes" > <><><><><><><><><><><> > > > "DaveC" wrote: > > > Hi Folks, > > > > I am using the following formula to try to count how many cells contain a > > date within January but its not working for me > > > > =SUMPRODUCT((MONTH('Tracker 2010'!T6:T2643)=1)*('Tracker 2010'!T6:T2643<>" " > > )) > > > > Date format is 13/01/2010 in T6, 16/01/2010 in T7 and so on > > > > Any help you could give is appreciated > > > > Dave > > > > > >
From: steve on 28 May 2010 12:19 Hi DaveC, Try =SUMPRODUCT(--(MONTH('Tracker 2010'!T6:T2643)=1)) "DaveC" <DaveC(a)discussions.microsoft.com> wrote in message news:9598C038-25E9-49B2-8C29-D35282F0EF61(a)microsoft.com... > Hi Folks, > > I am using the following formula to try to count how many cells contain a > date within January but its not working for me > > =SUMPRODUCT((MONTH('Tracker 2010'!T6:T2643)=1)*('Tracker 2010'!T6:T2643<>" > " > )) > > Date format is 13/01/2010 in T6, 16/01/2010 in T7 and so on > > Any help you could give is appreciated > > Dave > > >
From: Luke M on 28 May 2010 13:26
=SUMPRODUCT(--(TEXT('Tracker 2010'!T6:T2643,"mm")="01")) -- Best Regards, Luke M "DaveC" <DaveC(a)discussions.microsoft.com> wrote in message news:9598C038-25E9-49B2-8C29-D35282F0EF61(a)microsoft.com... > Hi Folks, > > I am using the following formula to try to count how many cells contain a > date within January but its not working for me > > =SUMPRODUCT((MONTH('Tracker 2010'!T6:T2643)=1)*('Tracker 2010'!T6:T2643<>" > " > )) > > Date format is 13/01/2010 in T6, 16/01/2010 in T7 and so on > > Any help you could give is appreciated > > Dave > > > |