Formula or Function for call log tracking

[kor123]

Hi, I was wondering if anyone would possibly help me with finding a easy and fast way to track call logs. I am looking for a way to track the total number of in house calls, outgoing calls to customers, Average call duration and total call time. I have attached a sample of what the call logs look like. Excel is kind of new to me so any help would be great.
Attached Files Attached Files

[FDibbins]

See if this will get you started...

	L	M	N	O	P	Q
1		Unpark	Conf.	In	Transfer	Out
2	10/7/2015	6	1	2	1	2

M2=COUNTIFS($A:$A,">="&$L2,$A:$A,"<"&$L2+1,$D:$D,M$1)
copied across

You can use the same method to count between date ranges
M3=COUNTIFS($A:$A,">="&$L2,$A:$A,"<="&$L3+1,$D:$D,M$1)

[kor123]

Do you mind explaining a little more in detail on how to apply this?

[kor123]

I think I am following you. I will see what I come up with. thank you for the reply.

[FDibbins]

Sorry for the delay in replying, RL called

M2=COUNTIFS($A:$A,">="&$L2,$A:$A,"<"&$L2+1,$D:$D,M$1)

This is the same as the basic COUNTIF() function, however, COUNTIFS() allows for more than 1 criteria to be tested. So in that example...
=COUNTIFS(A:A...this means look in the range that has the dates...which is column A
,">="&$L2,....this means to look for any dates >= the date in L2
then again in range $A:$A....the range with the dates
,"<"&$L2+1,...look for any dates that are less than < the date in L2 + 1
I used L2 + 1 because you also have times in column A, so I could not just use =L2, because even just 1 minute into the day means that date does not = just "the date"
and finally...
$D:$D...this is teh range with the codes in it
,M$1) this if the heading of thet column, which adjusts as you copy it across

The 2nd formula is pretty much the same thing....
M3=COUNTIFS($A:$A,">="&$L2,$A:$A,"<="&$L3+1,$D:$D,M$1)
only different, I am using a 2nd reference for the 2nd date

Hope that helps?