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...
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.
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- Thanks much Hans.
You should be able to attach a file to a private message to me (click on my user avatar)