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.