Thread
:
Sm Product a Calendar Month Range?
View Single Post
#
3
Don Guillett
Posts: n/a
assuming valid dates in A to count
=sumproduct((month(rngA)=1)*1)
--
Don Guillett
SalesAid Software
"John" wrote in message
...
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
Reply With Quote