Formula Required

[Drewmyster]

Hi there,

I need a formula to count the number of occurrences that a piece of work was completed; therefore, a formula to look up a date range and match a person's name to that date.

For example;

I want to view from one page how many reports "Stacy" ran in January 2011 compared to her colleagues "Darren" "Jake" and "Michelle".

At present the data is arranged as follows;

04/01/2011 Stacy
08/01/2011 Jake
10/01/2011 Michelle
12/01/2011 Jake
15/01/2011 Jake
18/01/2011 Stacy
20/01/2011 Darren
22/01/2011 Stacy
24/01/2011 Stacy
26/01/2011 Michelle
28/01/2011 Jake
31/01/2011 Stacy

How do I return the number of times Stacy ran the report in January (without using a filter)?

Many thanks

 

[VoG]

Duplicate http://www.mrexcel.com/forum/showthread.php?t=549051

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).