Why is it that when I change the field setting to "Count" it changes the value to 176? I mean, some fields are to be blank if they don't meet the criteria (see formula in colums O through R on Export Worksheet). Is this because the PivotTable sees the formula and "counts" the cell even though the formula does not populate the cell with a "1" ?

Thanks for any explaination and possible solution whereby a PivotTable can still ouput what I need (including the ability to "double click" on a value and return only those records).