Count in Pivot Tables
 

Hi,

What formula would I use (or can I use one) in Pivot Tables to get a Count
of the "Yes" in a column instead of a total of the column Q.

Normally I was use the Countif formula but I can't get it to work.

Thanks
JoAnn


--
Very Thankful

Count in Pivot Tables
 

Place the field with the yes values in the left column (you will get a
listing of all of the possible values that are in that column). Now just add
the same field again but place it in the center section. This should give you
a count of all of the yes values (along with the rest which you can just
hide)...
--
HTH...

Jim Thomlinson


"Joey041" wrote:

Hi,

What formula would I use (or can I use one) in Pivot Tables to get a Count
of the "Yes" in a column instead of a total of the column Q.

Normally I was use the Countif formula but I can't get it to work.

Thanks
JoAnn


--
Very Thankful