I have two collumns:
A B
YEAR MONTH
2006 June
2006 June
2007 Sept
2008 october
2006 January
2006 Februrary
2007 March
2008 March
On a separate sheet I have:
Year 2006
Month jan feb mar apr may jun jul aug sep oct nov
#instances ? ? ? ? ? ? ? ? ? ? ?
Now what function would grab only the 2006 year data and COUNT the number of Januarys?
***I would also like it to grab the entire collumn because the data sheet is constantly being updated.
Thank you soooo much!
Bookmarks