Count multiples and add to pivot table
 

Hello-

I'm pretty new at this.

I have a pivot table.
Question 1: If I "format" my table, just the way I like it, is there a way
to "freeze" the format and just update the data? Without losing the font,
width, etc.

Question 2: In column X, I would like to take the data from Column A "Hats",
look at another worksheet named RawData, count how many occurances of "Hats"
there are in this file and put the results in column X. In column Y, I would
like the count of RED Hats, in Z, the count of BLUE Hats, in AA, any other
not red or blue hat count.

I really appreciate all the help this group provides.
Thanks in advance.

Count multiples and add to pivot table
 

Assuming A2 contains the name of the hat you want to count

In X2
=countif(RAWDATA!A:Z,"*" & a2 & "*")

I am not sure how you determine the color of the hat.

I would need to know more about your data. Perhaps with the sumproduct
formulas

=Sumproduct(--(Rawdata!$A$1:$A$500=A2),--(RawData!$B$1:$B$500="RED"))


--
Regards,
Tom Ogilvy


"DTTODGG" wrote in message
...
Hello-

I'm pretty new at this.

I have a pivot table.
Question 1: If I "format" my table, just the way I like it, is there a way
to "freeze" the format and just update the data? Without losing the font,
width, etc.

Question 2: In column X, I would like to take the data from Column A
"Hats",
look at another worksheet named RawData, count how many occurances of
"Hats"
there are in this file and put the results in column X. In column Y, I
would
like the count of RED Hats, in Z, the count of BLUE Hats, in AA, any other
not red or blue hat count.

I really appreciate all the help this group provides.
Thanks in advance.