Counting Dates in a Range

I seek help to find a formula to do the following:
I have a range (P2:AB659) that is populated with dates entered 1/16/06
format and displayed as 6-Jan format. I need to count the number of cells
containing any date in January, any date in February, etc.

TIA, Matt

=SUMPRODUCT(--(MONTH(P2:AB659)=1)

change the 1 to the month number you want to count (ie. Jan=1, Feb=2, Mar=3,
etc.)

"Matt7102" wrote:

> I seek help to find a formula to do the following:
> I have a range (P2:AB659) that is populated with dates entered 1/16/06
> format and displayed as 6-Jan format. I need to count the number of cells
> containing any date in January, any date in February, etc.
>
> TIA, Matt
>
>

What is the purpose/meaning of the double dash (--) in this formula?

Thanks

"Sloth" wrote:

> =SUMPRODUCT(--(MONTH(P2:AB659)=1)
>
> change the 1 to the month number you want to count (ie. Jan=1, Feb=2, Mar=3,
> etc.)
>
> "Matt7102" wrote:
>
> > I seek help to find a formula to do the following:
> > I have a range (P2:AB659) that is populated with dates entered 1/16/06
> > format and displayed as 6-Jan format. I need to count the number of cells
> > containing any date in January, any date in February, etc.
> >
> > TIA, Matt
> >
> >

It turns an array of logical terms into 1's and 0's. This way they can be
summed (TRUE/FALSE is ignored when summing).

Example:
{TRUE,TRUE,FALSE,TRUE}->{1,1,0,1}

NOTE: The formula is missing a close parenthesis and should be

=SUMPRODUCT(--(MONTH(P2:AB659)=1))

"Bean123r" wrote:

> What is the purpose/meaning of the double dash (--) in this formula?
>
> Thanks
>
> "Sloth" wrote:
>
> > =SUMPRODUCT(--(MONTH(P2:AB659)=1)
> >
> > change the 1 to the month number you want to count (ie. Jan=1, Feb=2, Mar=3,
> > etc.)
> >
> > "Matt7102" wrote:
> >
> > > I seek help to find a formula to do the following:
> > > I have a range (P2:AB659) that is populated with dates entered 1/16/06
> > > format and displayed as 6-Jan format. I need to count the number of cells
> > > containing any date in January, any date in February, etc.
> > >
> > > TIA, Matt
> > >
> > >

Thanks for the help, and the short tutorial on explaining the formula
function... however, using a smaller dataset to test, the formula does not
return the correct result for January. Works fine for all other months.
When I add a date in the range other than January to the test dataset, (or
delete an existing) all is well for the month altered. January is just NOT
working...any ideas?

"Sloth" wrote:

> It turns an array of logical terms into 1's and 0's. This way they can be
> summed (TRUE/FALSE is ignored when summing).
>
> Example:
> {TRUE,TRUE,FALSE,TRUE}->{1,1,0,1}
>
> NOTE: The formula is missing a close parenthesis and should be
>
> =SUMPRODUCT(--(MONTH(P2:AB659)=1))
>
> "Bean123r" wrote:
>
> > What is the purpose/meaning of the double dash (--) in this formula?
> >
> > Thanks
> >
> > "Sloth" wrote:
> >
> > > =SUMPRODUCT(--(MONTH(P2:AB659)=1)
> > >
> > > change the 1 to the month number you want to count (ie. Jan=1, Feb=2, Mar=3,
> > > etc.)
> > >
> > > "Matt7102" wrote:
> > >
> > > > I seek help to find a formula to do the following:
> > > > I have a range (P2:AB659) that is populated with dates entered 1/16/06
> > > > format and displayed as 6-Jan format. I need to count the number of cells
> > > > containing any date in January, any date in February, etc.
> > > >
> > > > TIA, Matt
> > > >
> > > >

I have no idea why it wouldn't be working. I made a small list to test that
worked fine. Can you show the list, formulas, and results? Is it giving an
error, or the wrong value? What value does the formula produce? What value
should it be?

"Matt7102" wrote:

> Thanks for the help, and the short tutorial on explaining the formula
> function... however, using a smaller dataset to test, the formula does not
> return the correct result for January. Works fine for all other months.
> When I add a date in the range other than January to the test dataset, (or
> delete an existing) all is well for the month altered. January is just NOT
> working...any ideas?
>
> "Sloth" wrote:
>
> > It turns an array of logical terms into 1's and 0's. This way they can be
> > summed (TRUE/FALSE is ignored when summing).
> >
> > Example:
> > {TRUE,TRUE,FALSE,TRUE}->{1,1,0,1}
> >
> > NOTE: The formula is missing a close parenthesis and should be
> >
> > =SUMPRODUCT(--(MONTH(P2:AB659)=1))
> >
> > "Bean123r" wrote:
> >
> > > What is the purpose/meaning of the double dash (--) in this formula?
> > >
> > > Thanks
> > >
> > > "Sloth" wrote:
> > >
> > > > =SUMPRODUCT(--(MONTH(P2:AB659)=1)
> > > >
> > > > change the 1 to the month number you want to count (ie. Jan=1, Feb=2, Mar=3,
> > > > etc.)
> > > >
> > > > "Matt7102" wrote:
> > > >
> > > > > I seek help to find a formula to do the following:
> > > > > I have a range (P2:AB659) that is populated with dates entered 1/16/06
> > > > > format and displayed as 6-Jan format. I need to count the number of cells
> > > > > containing any date in January, any date in February, etc.
> > > > >
> > > > > TIA, Matt
> > > > >
> > > > >