I'm not very good with Excel and I need to gather some data quickly. I have start date/time in 1 column with end date and time in a second column. I have totalled the hours with no issue between the two. The second piece of data I need is items by date with total hours. So, if 10 requests were made on a given date, I need to know the number of requests and the total number of hours required. I have attached a sample file if that helps.
sample.xls
Hi and welcome to the forum.
If i get your request, correctly, then use COUNTIF and SUMIF functions.
=COUNTIF($A$2:$A$29;A2)
=SUMIF($A$2:$A$29;A2;$D$2:$D$29)
Hope to helps you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Re: Date Range totals
This helps. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks