[Webinar] Streamline your web hosting managementRegister Today

x
  • 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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