Pivot Table - Average of counts
 

Reposting...

I have a table with 3 columns of text where column A maps to multiple values
in col B which maps to multiple values in col C.

e.g.
X Y Z
X Y W
X U V
X T <blank
S R Q

I'm trying to make a pivot table that shows me:
Col A Col B Count of Col C per Col B:
X Y 2
X U 1
X T 0
S R 1

Summarized by the total count of Col C as well as the Average Count of C per
B. So if there were 1 C for each B, the average would be 1. If each B had 2
Cs, the average would be 2, etc. I can't seem to find a way to show that
subtotal and overall total (so across all of A, the total number of C divided
by the total number of B). I can only average the value, which in this case
returns an error since it's text.