Suggestions, please

[Eric]

Hello all,

I have a database spreadsheet listing the staff name in column A and the
type of transactions they have processed in column B within a certain
period, which is something like this:
Staff Txn
A10 T
A10 T
A10 S
A10 E
A15 S
A15 T
A15 E
A20 T
A20 S
A20 S
A20 E


Now I want to make a summary of the number of transactions each staff has
done in a table format like this:
column F column G column H
Staff T S E
row 5 A10
row 6 A15
row 7 A20


I have tried the "countif" with the "and" functions but I can't get them
works (it always return "0")

Any suggestion would be highly appreciated.


Eric

 

[Andy Brown]

Any suggestion would be highly appreciated.

Try a pivot table, via the Data menu.

Step 1 ; data = Excel list or d-base, report type = Pivot Table. Next.

Step 2 ; select your data on the worksheet. Next.

Step 3a ; Layout. Drag Staff to Row area, Txn to Column area, Txn to Data
area. OK.

Step 3b ; specify the table location. Finish.

This'll give you a summary plus row & column totals. If you don't want 'em,
rightclick & hide.

HTH,
Andy