Help with report totals required

[WRP666]

A post from a "newby" I'm afraid. I'm new to Excel so please be gentle. I need to find out how to create some totals in an Excel spreadsheet. I have imported some data into Excel that relates to outstanding tickets from our help desk (one ticket per row). Each ticket is assigned a three-character category (eg: ADM, PRT, SEC and so on). At the end of my imported ticket data I would like to have totals that summarise the number of tickets per category, as follows:

TICKET CATEGORY TOTALS
-------------------------------
ADM: 23
PRT: 9
SEC: 42

...etc. In my capacity an Excel "virgin" I have no idea how to do this. Could someone give me a push in the right direction?

Thanks in advance.

[MarvinP]

Hi WPR666 and welcome to the forum,

Find attached two different ways to do the problem. I've created some sample data with formulas to show answers.

[WRP666]

Hi Marvin. Thanks for your response. The pivot table is certainly the more elegant solution but I don't know how to create pivot tables so it's time for me to stop being lazy and do some study. Thanks again.