Formula Help - ce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top