Hello,

I am working with excel 2003 on WindowsXP.

Column A contains user names, often duplicated. Column D contains the
time that user was working on a project eg HH:MM:SS.

What formula can I create in column F that looks at the names in
Column A and adds up the amount of time they have spent on a project.


EG if John Smith appears 12 times in Column A , then column F will
show the cumulative time he has been working along with his name.

Thanks in advance for your help.

Ket
London

=SUMPRODUCT(--(A2:A40="John Smith"),D2:D40)

"Ket" wrote:

Hello,

I am working with excel 2003 on WindowsXP.

Column A contains user names, often duplicated. Column D contains the
time that user was working on a project eg HH:MM:SS.

What formula can I create in column F that looks at the names in
Column A and adds up the amount of time they have spent on a project.


EG if John Smith appears 12 times in Column A , then column F will
show the cumulative time he has been working along with his name.

Thanks in advance for your help.

Ket
London

Have you looked in HELP index for SUMIF?

--
Don Guillett
SalesAid Software

"Ket" wrote in message
...
Hello,

I am working with excel 2003 on WindowsXP.

Column A contains user names, often duplicated. Column D contains the
time that user was working on a project eg HH:MM:SS.

What formula can I create in column F that looks at the names in
Column A and adds up the amount of time they have spent on a project.


EG if John Smith appears 12 times in Column A , then column F will
show the cumulative time he has been working along with his name.

Thanks in advance for your help.

Ket
London