Pivot Table

[bugmenot]

This is my table

ColumnNamess s1 s2 s3
row1---------------------- 3 3 3
row2---------------------- 5 5 4
row3---------------------- 4 4 4
row4---------------------- 3
row5---------------------- 4 4 4
row6---------------------- 4 4 4
row7---------------------- 5 5 5
row8---------------------- 4 4 4

What I want to do is an output like below, which is showing the count of 3, 4 and 5 for each column.

s1 s2 s3
3- 1 2 1
4- 4 4 5
5- 2 2 1
blank 1 0 0

Thanks for helps.

[Richard Buttrey]

Hi,

With your data in B1:D9 and the values 3,4,5 in say A12:A14, in B12 and copied to D14

=COUNTIF(B$2:B$9,$A12)

Not quite sure what the blanks refer to since a 1,0,0 doesn't seem consistent with your data.

HTH