Hi everybody...
Here's my situation. I work at a lan house, and I need to sum the tota
hours that each person has played.
Each user has a number, but there is a record for each time he ha
played.
For example:
A B C
(number) (name) (played hours)
456 Daniel 01:00:00
456 Daniel 02:00:00
456 Daniel 01:00:00
456 Daniel 04:00:00
456 Daniel 00:30:00
456 Daniel 01:00:00
469 Rachel 02:00:00
469 Rachel 03:30:00
469 Rachel 02:30:00
469 Rachel 02:00:00
469 Rachel 01:00:00
and so on...
so this is what I came up with:
=SUMIF(A:A;"=456";C:C) (for daniel)
=SUMIF(A:A;"=469";C:C) (for rachel)
and so on...
but there are 7 thousand members....
I need to find a way to do this in a batch way...
can anyone help me??
Thanks a lot :cool
--
Message posted from
http://www.ExcelForum.com