Well, just a guess, if you changed the range, verify that both ranges
are the same size.


Hopes this helps.
....
Per

On 8 Mar., 13:44, Kimti wrote:
It gave me "#value" error. Please let me know what set up do I need to do to
clear this error.

Thanks,
Kimti



"Per Jessen" wrote:
Thanks for your reply.

The sheet reference need to be just before the cell reference:

=SUMPRODUCT(--(MONTH(Sheet1!$A$2:$A$100)=1),--(Sheet1!$B$2:$B
$100="John C"))

---
Per

On 7 Mar., 23:15, Kimti wrote:
Thank you Per, this worked on the same sheet in different cell. I would like
to have this summary on different sheet. I tried following:

=SUMPRODUCT(SHEET1!(MONTH($A$2:$A$100)=1),SHEET1!( $B$2:$B100="JOHN C"))
But this did not work, please provide further help.

Thanks,

Kimti

"Per Jessen" wrote:
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.

.- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

.- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -