Hi Tom-

Another thought:

If you want to display the results elsewhere rather than having subtotals
inserted in the original range, you might want to try the DSUM function. It
will selectively sum the times using the user names as criteria regardless of
how the records are sorted.

HTH |:)

"tom300181" wrote:


I have a table that has a column of users (many duplicates) and a column
of times. I need to be able to produce a table that will show the user
(once only) and a sum of all of their times from table one.

Is this possible?

Thanks

Tom


--
tom300181
------------------------------------------------------------------------
tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580
View this thread: http://www.excelforum.com/showthread...hreadid=386102