Thread: 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.

Your workbook example only goes to Row 38 so my formula reflects that - there are a few things - avoid merged cells if at all possible as cell AS is with merged cells and the time values are formatted as general - they should be custom formatted as h:mm:ss
I would use sumproduct - I have placed this into AZ8 - see attached workbook
=SUMPRODUCT(('Page 1'!C1:C38="Total")*('Page 1'!AS1:AS38))
I cannot stress enough that merged cells can play havoc with workbooks - avoid them and used center across cell format instead

Hope this helps.
Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s) questions.”

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST