Keeping statistics on 1 sheet based info on another

jbyrne

Board Regular
Joined
Feb 22, 2002
Messages
178
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.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top