View Single Post
  #1   Report Post  
John
 
Posts: n/a
Default 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