Tucker2008
New Member
- Joined
- Aug 19, 2013
- Messages
- 37
- Office Version
- 2013
- Platform
- Windows
Hello,
The count function in a pivot table counts all fields with a formula, even if the formula returns blank. Is there a way to create a calculated field that only counts the cells with Text in them. In the example below, there are 30 Rows, but only 9 are COMPLETE. The standard count function in the pivot table returns 30. I want to do a Calc Field that says something to the effect of
= IF('QE Review'= "COMPLETE",1,0) and then Sum the total (which would be 9). I cannot get it to work though.
Appreciate any and all help.
The count function in a pivot table counts all fields with a formula, even if the formula returns blank. Is there a way to create a calculated field that only counts the cells with Text in them. In the example below, there are 30 Rows, but only 9 are COMPLETE. The standard count function in the pivot table returns 30. I want to do a Calc Field that says something to the effect of
= IF('QE Review'= "COMPLETE",1,0) and then Sum the total (which would be 9). I cannot get it to work though.
Appreciate any and all help.
QE Review |
COMPLETE |
COMPLETE |
COMPLETE |
COMPLETE |
COMPLETE |
COMPLETE |
COMPLETE |
COMPLETE |
COMPLETE |