Thread: Pivot Tables
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Pivot Tables

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?