Forum Discussion

hitman_semsem2007's avatar
hitman_semsem2007
Copper Contributor
Apr 19, 2025

count some data

Hello My friend,

 

Can anyone please inform me what is the Excel equation for the below details:

 

I have 2 columns first one the state and it have two cells only with C or T....and the second column is for agent name which has many cells more than 3k...so i need to know like the cells on the right every agent how many total it have of c and t and how many separately.

 

Thanks in advance.

 

BI & Data Analysis

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 21, 2025

    You can create a pivot table based on the data. Add Agent to the Rows area, and State to both the Columns area and the Values area. See Pivot Tables in Excel if you're not familiar with them.

    If you have Microsoft 365 you can also use the new PIVOTBY function.

    In the screenshot below, the PIVOTBY result is at the top, and the pivot table below it.

Resources