i have a table with 3 columns...column A has the date, column B has the
time, and column C has the # of transactions. how do i sum up the
transactions that occur at the same time.

e.g.
Column A Column B Column C
12/15/2005 9:45 AM 2
12/15/2005 9:45 AM 3
12/15/2005 10:00 AM 4

So instead of having 2 entries for 9:45 AM, i just want one for each
time period so the # of transactions would be 5.

note: this data is pulled from a report and also i do not want to use a
pivot table either


--
kdp145
------------------------------------------------------------------------
kdp145's Profile: http://www.excelforum.com/member.php...o&userid=29594
View this thread: http://www.excelforum.com/showthread...hreadid=493776