Keeping statistics on 1 sheet based info on another

[jbyrne]

Can anyone help me?
In column A I have a date column filled with week ending dates
In column B, I have 8 digit file numbers regarding promise of payment
In column C, I have 2 letter code "TO" or "TR"
In column D, I have employee initials
In column E, I have a "payment in by date"
In column F, I have file numbers of disputed accounts
In column G, I have file numbers for good jobs but no message left.
In column H, I have Column Labeled "Payment come in?"

I will be entering info in each of the columns on a daily basis. I would like the following statistics on Sheet 2.

for each employee (column d)
1.the number of promises for each week ending date
2.the number of to's and the total number of tp's per employee by week ending date.
3. the percentage of "to promises" that came in and the percentage of "tp promises" that came in.

[Anne Troy]

Hi jbyrne. If you've set up your file like a *real* database file, you can just use the Data-Subtotals feature.

To set it up like a *real* database, you need column headings in Row 1, and first record in Row 2. No completely blank columns and no completely blank rows in your data.

[Aladin Akyurek]

Care to provide 10 rows of data (including the labels) from your Sheet1? Just select an empty cell, type =, select 10 rows of data, hit F9, copy what you see and post the copied bit in the follow-up.