• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

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
0
Umesh
Asked:
Umesh
  • 3
  • 2
1 Solution
 
cyberkiwiCommented:
H2:    =IF(F2=0,0,D2/F2)
I2:     =IF(F2=0,0,E2/D2)

And copy down
0
 
UmeshMySQL Principle Technical Support EngineerAuthor Commented:
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.
0
 
cyberkiwiCommented:
F2, D2 are from your attached file...
Did you attach a wrong file?
0
 
UmeshMySQL Principle Technical Support EngineerAuthor Commented:
Thanks I got it. But For Daily avg Duration the function is not wortking.
0
 
UmeshMySQL Principle Technical Support EngineerAuthor Commented:
Now it is working thanks cyberkiwi:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now