Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help - ce
I have a report which contains the following data (sample below)
S_Name Day Month Year Trans_Amount Date Time North 2 3 2010 236 2/28/10 2:00 PM 2:00pm Using the example above I need a formula that looks at this source sheet and sums the transaction amount by North for the Mar 2 2010 (format 03/02/2010) when the time is = 2:00pm on March 1 2010 and less than 2:00pm on March 2 2010. In my reports sheet the date can be formated any way however I have chose Cell A3 contains text Mar (could be any month) and cell B3:b33 contains the numbers 1 through 33 which represents the day of the month (this format can be changed if required) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|