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?