Results 1 to 4 of 4

Aht

Threaded View

kishoremcp Aht 01-26-2012, 06:37 PM
smuzoen Re: Aht 01-26-2012, 09:20 PM
kishoremcp Re: Aht 01-26-2012, 11:52 PM
royUK Re: Aht 01-27-2012, 03:53 AM
  1. #1
    Forum Contributor
    Join Date
    01-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    402

    Arrow Aht

    I am able to calculate the total number of Chats Served (Column K13) but not getting the AHT Handeled (AS13) using the same formula.
    Please help me.
    Attaching the data for testing.


    =SUMIF('Page 1'!C1:C53,"Total",'Page 1'!K1:K53)
    I am using the below formula to get the handeled AHT i am not getting it...

    =SUMIF('Page 1'!C1:C53,"Total",'Page 1'!AS1:AS53)
    I am sorry to change the sheet1 name to "Page 1". Please change it and help me. Even after changing the sheet name it is not working.

    Please help.
    Attached Files Attached Files
    Last edited by kishoremcp; 01-27-2012 at 12:00 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1