Hi, I am new and not sure how this works but I am really desperate for some help.
I have a workbook which contains 6 worksheets, each wrksht relates to an office which records staff jobtitles(L5:L100), start dates(K5:K100) etc.
On my summary tab I have a start date(B1) and end date (b2). What I am trying to acheive is an automated formula that will tell me how many people started between the two dates that equal a specific jobtitle.
I can get the formula to tell me how many say administrators there are, and I can get the formula to tell me the number of people that started between the date range, but the problem I have is joining the 2 together to make 1 formula!