Hi,
Is it possible to do the below?
On the attached:
I would like to know the total minutes for authorised absence for each department during a certain month.
Col A = Dept
Col B= Sickness OR Authorised absence
Col H= Dates absent
Col M= Total Mins
Warehouse = how many mins were Sickness during May.
I was thinking sumproduct but don't know how incorporate date fields. Is this possible?
Thanks for the help in advance
Last edited by preddy1110; 06-06-2014 at 07:28 AM.
We(3 people) still are waiting for your feedback in this your own thread...
http://www.excelforum.com/excel-form...-criteria.html
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.
Kind of had a go
=SUMPRODUCT((May!$H$1:$H$10000<=DATE(2014,7,31))*(May!$H1:$H$10000>=DATE(2014,5,1))*(May!$B1:$B$10000="Sickness")*(May!$A$1:$A$10000="Business Development")) = Gives me counts/instances
However not sure how to work out the minutes, I tried the following by adding *('May'!$M$1:$M$10000), it didn't work. A bit stumped on this
=SUMPRODUCT((May!$H$1:$H$10000<=DATE(2014,7,31))*(May!$H1:$H$10000>=DATE(2014,5,1))*(May!$B1:$B$10000="Sickness")*(May!$A$1:$A$10000="Business Development")*('May'!$M$1:$M$10000)
Is it possible to work out the total minutes for Sickness, for each department during a given month?
Thanks!
Haha never mind my formula does work, not sure why it wasn't for the past 2 hours!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks