Hi there,
So one one spreadsheet I have this:
Complaint ID # Team Coordinator Date Received Lessee First line of Address Borough Category Subcategory Allocated to Team
101 jb 03-Jan-14 gftrs th dr h dr htrd Defect blah blah bg West
102 jb 07-Jan-14 trs tr htd Defect blah blah bg West
The rows go up to 200 as more data will be filled in over time.
On another worksheet I have this:
Date from 01/01/2014
Date to 31/01/2014
Team Compliments Complaints
West
North
South
S106
P&Q
In the complaints column I want to count how many rows are in the first worksheet if the date range in date received is between (inclusive) the date range above and if the team name is the same. Whenever I do this ()I am sure I'm filling all details in correctly) it comes up with zero.
Please help! Have attached workbook as well.
Thanks
LucieNHHO Complaints Spreadsheet test 27.1 (version 2).xls
Bookmarks