Formula to sum up the dates
Hi
Look at this:
=SUMPRODUCT(--(MONTH($A$2:$A$100)=1),--($B$2:$B$100="John C"))
You can change the second criteria ("John C") to a cell reference if
you have list with your 11 employees which you want to use.
Regards,
Per
On 7 Mar., 21:59, Kimti wrote:
I have column A with the date and column B with the name of person assigned
for the task. I would like to count how many tasks assigned to any particular
person for whole month based on column A dates.
A * * * * * * * * * * * * * * * * * B
Jan 10, 2010 * * * * * * * *John C
Jan 12, 2010 * * * * * * * *Jason B
Jan 13, 2010 * * * * * * * *John C
John C was assigned two tasks in Month of Jan. Usally I have about 80 tasks
for 11 employees per month.
Thank you in advance for your help.
|