Sm Product a Calendar Month Range?

I have a list of days for the year 2005 in Col A. In Col B opposite each day
in 2005 (Col A) I have the location I have visited. Is it possible to add up
the number of times I was say in London, for the month of January, without
having to enter a specific sumproduct range in the formula?

Thanks

No, you need to enter a range, you might want to enter a range that will
cater to future needs (making it larger than at present necessary)

=SUMPRODUCT(--(MONTH(Range1)=1),--(ISNUMBER(Range1)),--(Range2="London"))

Regards,

Peo Sjoblom

"John" wrote:

> I have a list of days for the year 2005 in Col A. In Col B opposite each day
> in 2005 (Col A) I have the location I have visited. Is it possible to add up
> the number of times I was say in London, for the month of January, without
> having to enter a specific sumproduct range in the formula?
>
> Thanks
>
>
>
>

assuming valid dates in A to count
=sumproduct((month(rngA)=1)*1)

--
Don Guillett
SalesAid Software
[email protected]
"John" <[email protected]> wrote in message
news:[email protected]...
> I have a list of days for the year 2005 in Col A. In Col B opposite each
day
> in 2005 (Col A) I have the location I have visited. Is it possible to add
up
> the number of times I was say in London, for the month of January, without
> having to enter a specific sumproduct range in the formula?
>
> Thanks
>
>
>

Note that it will count blank cells as January


Regards,

Peo Sjoblom

"Don Guillett" wrote:

> assuming valid dates in A to count
> =sumproduct((month(rngA)=1)*1)
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "John" <[email protected]> wrote in message
> news:[email protected]...
> > I have a list of days for the year 2005 in Col A. In Col B opposite each
> day
> > in 2005 (Col A) I have the location I have visited. Is it possible to add
> up
> > the number of times I was say in London, for the month of January, without
> > having to enter a specific sumproduct range in the formula?
> >
> > Thanks
> >
> >
> >
>
>
>