C
Curtis
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
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