Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
couting transactions for same time
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
couting transactions for same time
One way could be to enter the date to total in D1,
And the time to total in D2, And try this formula: =SUMPRODUCT((A1:A100=D1)*(B1:B100=D2)*C1:C100) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "kdp145" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Times | Excel Discussion (Misc queries) | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |