Aht

[kishoremcp]

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.

[smuzoen]

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.”

[kishoremcp]

Hi Anthony,
Thanks a lot. You really saved me and my time as well. I am really thankful to you.
Thanks again.

[royUK]

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