Please help excel 2016

Closed
Txsky84 - Feb 24, 2017 at 07:22 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Feb 28, 2017 at 11:21 AM
Hello,

I have an excel workbook for our call center metrics and i need to accomplish the following

On the sheet named calculations and a sheet named data.

In sheet named calculations I have the agent name and then columns for Total calls, TalkTime,Etc

Example ( in sheet Calculations )
Column A Agent 1 Column D Total Calls

Need to accomplish the following


If in sheet Data Column P is equal to True show all values for Totals Calls in Column C for Agent 1 in Column B displayed in Column D on Sheet Calculations


1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Feb 28, 2017 at 11:21 AM
Hi Txsky84,

Could you provide some sample data, as it is hard to understand what you are trying to achieve.

Best regards,
Trowa
0