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 "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 |
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 "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 |
All times are GMT +1. The time now is 07:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com