Hello Friends,
In the attached Excel Sheet. I want to add the total time of trucks waited on a particular date in the sheet 2 named datewise. The waiting time is mentioned in the sheet 1 named truckwise.
Please help.
Lokpal Singh Panwar
Ajmer (Rajasthan)
Last edited by lokpal.panwar; 03-12-2013 at 05:15 AM.
Try in H7 and copy down.
=SUMPRODUCT(((DAY(Truckwise!$K$5:$K$100)=DAY(Datewise!B7))*(Truckwise!$M$5:$M$100)))
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.
In the same file if i want to count also the no. of trucks then ??
In F7 and copy down.
=SUMPRODUCT((DAY(Truckwise!$K$5:$K$100)=DAY(Datewise!B7))*(Truckwise!$J$5:$J$100<>""))
There u go.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks