Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract month number from month name | Excel Discussion (Misc queries) | |||
PivotTable - Count by Month | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Convert week number into calendar month? | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions |