To do what you want you need to transform your source data to a paired value
orientation

This That
PR e
PR m
PS e
PR m
PR e
PR m

At that point it becomes failry easy to get your count of e's.

--
HTH...

Jim Thomlinson


"Maureen B" wrote:

I have a data source that has four columns of data that are all similar. I
want to create one pivot table that would count the items in each column and
provide me with a number for each of the variables. An example of the data
is below.

PR PS PV ST
e m e m
m e e e
e e e e
e m e e

I want to know how many e's are in each column. When I try to do this in
one pivot table it provides the same answer for each column. I have done
this in four separate tables but would like to have them al in one. How can
this be done?