Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Addition of a number of fields
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 |
#2
|
|||
|
|||
It's called Subtotals:
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "tom300181" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Use an array formulat: =sum(if(a1:a25="Peter",b1:b25)) in cell say h1 to get all "Peter" in a1:a25 and their corresponding values in b1:b25, =sum()'ed up, is an array formula, so, to enter it you press ctrl-shift-enter, not just enter. Danny On Mon, 11 Jul 2005 05:40:55 -0700, 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 -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
doubling a number X number of times | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
making a number be text | Excel Worksheet Functions |