Forum Discussion
Subtotals and Counts by name
I have a spreadsheet with Name, Status, Worker Code and Gross Pay. Employees are listed multiple times due to multiple pay periods. Name Status Code Gross Pay Name 1 Nam...
Each employee is listed multiple times and there are five codes. Codes are the same for each individual employee. Suppose there are 20 employees in Code 5220, even though there are approximately 100 lines (due to employees listed multiple times because of multiple pay periods). I want to see that there are 20 employees in that code, not approximately 100. Hope that helps and does not confuse more! Thanks - Bob
Could you provide an example of what the output should look like?
A sample workbook would be handy too. Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Attached is a small example. Did not see where I could attach the file. So I just pasted. Thank you
NAME STATUS NAICS WORKER'S COMP GROSS PAY
Arnold, Colquitt Active 5606 - Supevisor $0.00
Arnold, Colquitt Active 5606 - Supevisor $0.00
Arnold, Colquitt Active 5606 - Supevisor $0.00
Arnold, Colquitt Active 5606 - Supevisor $0.00
Becker, Anthony Active 5606 - Supevisor $0.00
Becker, Anthony Active 5606 - Supevisor $0.00
Becker, Anthony Active 5606 - Supevisor $0.00
Becker, Anthony Active 5606 - Supevisor $0.00
Johnson, Mark Active 5606 - Supevisor $0.00
Johnson, Mark Active 5606 - Supevisor $0.00
Johnson, Mark Active 5606 - Supevisor $0.00
Johnson, Mark Active 5606 - Supevisor $0.00
Knoeber, Jason Active 5606 - Supevisor $0.00
Knoeber, Jason Active 5606 - Supevisor $0.00
Knoeber, Jason Active 5606 - Supevisor $0.00
Knoeber, Jason Active 5606 - Supevisor $0.00
Lopez Lanas, Hector Active 5606 - Supevisor $0.00
Lopez Lanas, Hector Active 5606 - Supevisor $0.00
Lopez Lanas, Hector Active 5606 - Supevisor $0.00
Lopez Lanas, Hector Active 5606 - Supevisor $0.00
Pressley, Chadwick Active 5606 - Supevisor $0.00
Pressley, Chadwick Active 5606 - Supevisor $0.00
Pressley, Chadwick Active 5606 - Supevisor $0.00
Pressley, Chadwick Active 5606 - Supevisor $0.00
5606 - Supevisor $50,307.80
There are 24 lines with code = 5606 but only 6 employees. The desired output is 6.
The output could be put in Row 32, Column B.Could you paste it as a table? This is rather confusing.
- Here it is as a table but not sure if it helps. How do you just attach a spreadsheet on this post. As you can see, there are 24 lines for code 5606 but only 6 employees. The desired outcome is 6. It could be placed in Column B - Row 32 on the subtotal line.
NAME STATUS NAICS WORKER'S COMP GROSS PAY
Arnold, Colquitt Active 5606 - Supevisor $0.00
Arnold, Colquitt Active 5606 - Supevisor $0.00
Arnold, Colquitt Active 5606 - Supevisor $0.00
Arnold, Colquitt Active 5606 - Supevisor $0.00
Becker, Anthony Active 5606 - Supevisor $0.00
Becker, Anthony Active 5606 - Supevisor $0.00
Becker, Anthony Active 5606 - Supevisor $0.00
Becker, Anthony Active 5606 - Supevisor $0.00
Johnson, Mark Active 5606 - Supevisor $0.00
Johnson, Mark Active 5606 - Supevisor $0.00
Johnson, Mark Active 5606 - Supevisor $0.00
Johnson, Mark Active 5606 - Supevisor $0.00
Knoeber, Jason Active 5606 - Supevisor $0.00
Knoeber, Jason Active 5606 - Supevisor $0.00
Knoeber, Jason Active 5606 - Supevisor $0.00
Knoeber, Jason Active 5606 - Supevisor $0.00
Lopez Lanas, Hector Active 5606 - Supevisor $0.00
Lopez Lanas, Hector Active 5606 - Supevisor $0.00
Lopez Lanas, Hector Active 5606 - Supevisor $0.00
Lopez Lanas, Hector Active 5606 - Supevisor $0.00
Pressley, Chadwick Active 5606 - Supevisor $0.00
Pressley, Chadwick Active 5606 - Supevisor $0.00
Pressley, Chadwick Active 5606 - Supevisor $0.00
Pressley, Chadwick Active 5606 - Supevisor $0.00
5606 - Supevisor $50,307.80