First let me say thanks in advance. I have the formulas close, but got lost trying to extract the data by month.
On the Cover Tab, I need E7 to look for the name in A7 and Match it with the name in column D on the 2014 Tab. Look for the date in E5 Feb2014), add all February dates in column E on Tab 2014 for that name and Count the incidents in column F on Tab 2014.
On the Cover Tab, I need E45 to look for what is typed into K41 (that information is in column D of the year Tabs), look at E43 (year) and D45 (month), add the incidents up in Column C for that month from that Tab (INT# on Cover Tab is ASSOCIATE THEFT on the year tabs).
I have attached what I am working on.
Bookmarks