SDWright13
New Member
- Joined
- Aug 6, 2014
- Messages
- 4
I have a pivot table where I have data broken down for the number of hours a person has worked on particular projects. The very last column of the table is the grand total and I can see how many hours total for the month each person submitted time for. This is a quick check to ensure everyone has input 100% of their time for the month. What I want to do is count the number of people that have submitted 100% of their time (>170 hours for a given month will be the criteria). I could use an equation and execute the countif command on the entire column to ensure I capture all the data as the rows increase or decrease (add or subtract employees), however the table will increase in width as well as I add projects, so my grand total column could move so I would have to change the column reference in my countif function each time the pivot table is refreshed. Is there a way to use the getpivotdata command and embed it in the countif command to perform this calculation? Here is an example of what my data looks like:
B C D E
Project A Project B Project C Grand Total
Employee A 32 52 90 174
Employee B 20 60 50 130
Employee C 40 53 80 173
I can perform the countif function such as this: countif(E:E,">170") and it will return a value of 2. The problem is that if I add a project then it will move the grand total column to column "F" and my count command will be looking at an incorrect column.
B C D E
Project A Project B Project C Grand Total
Employee A 32 52 90 174
Employee B 20 60 50 130
Employee C 40 53 80 173
I can perform the countif function such as this: countif(E:E,">170") and it will return a value of 2. The problem is that if I add a project then it will move the grand total column to column "F" and my count command will be looking at an incorrect column.
Last edited:
