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?

Hi,
your information is in columns A B C and D
in F1 enter PR, in G1 PS, in H1 PV in I1 ST, then in E2 enter e and in F2
enter

=COUNTIF(A2:A5,$E$2)

copy this formula to the right

"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?

I did this and it works but I would like to be able to do this in a pivot
table versus creating a separate table with the formula.

"Eduardo" wrote:

Hi,
your information is in columns A B C and D
in F1 enter PR, in G1 PS, in H1 PV in I1 ST, then in E2 enter e and in F2
enter

=COUNTIF(A2:A5,$E$2)

copy this formula to the right

"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?

Hi,
you will not be able to do a pivot table and get the results you are looking
for because your e are data and the pivot table can count or sum data, you
cannot say to count only the e because e and m are the same for the Pivot

"Maureen B" wrote:

I did this and it works but I would like to be able to do this in a pivot
table versus creating a separate table with the formula.

"Eduardo" wrote:

Hi,
your information is in columns A B C and D
in F1 enter PR, in G1 PS, in H1 PV in I1 ST, then in E2 enter e and in F2
enter

=COUNTIF(A2:A5,$E$2)

copy this formula to the right

"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?

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?