possible array question

[rdhhampton]

I have a spreadsheet that is taking entirely too much time to massage the data. In one column in the branch office number, in another is the type of account and in the third is a reason code. I need to have a count by branch office of every account code by reason code. For instance, Branch 3 has 36 RS accounts and of the 36 the count by each reason code. I can use SUMIFS but it is getting complicated that way. I can't use sort the data because I need to go to another report.

Any ideas? Maybe I just want this to be easier than it can be.

Branch Reason Type
3 O VC
1 1 VC
1 O RS
1 M RS
3 M CC
1 D RS
1 N AC
1 L RS
1 D QS
1 D RS
1 1 AC
1 L RS

[Norie]

Have you tried a pivot table?

[rdhhampton]

I tried the pivot table and I get totals for each but not by branch. I admit that I am no expert with pivot tables but I can't seem to get it to do the third part and break down by the branch.