Link to home
Create AccountLog in
Avatar of Umesh
UmeshFlag for India

asked on

Need Excel formula for calculating Daily Avg

I have an excel with some data attached here.
I want to calculate the Daily average calls and daily average call duration per day for each Name as in file.


New-Microsoft-Excel-Worksheet.xls
ASKER CERTIFIED SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Umesh

ASKER

Should I Copy the formula as I dont have F2 and D2 and H2.
can you attach the file so that I can have it.
F2, D2 are from your attached file...
Did you attach a wrong file?
Avatar of Umesh

ASKER

Thanks I got it. But For Daily avg Duration the function is not wortking.
Avatar of Umesh

ASKER

Now it is working thanks cyberkiwi: