counting how many times the scores was used

[Elainefish]

Hi,

I have a database where I want to make a summary of report
I want to count how many times the scores was used

I attached a copy of the sheet with the result I want to get (but I did it manually) QUESTION_count.xls
I want to do this automatically using excel formula

[Pete_UK]

Put 3 in H1, 4 in I1 and 5 in J1 as headers, then you can use these formulae in the cells stated:

H2: =COUNTIF(C2:E2,H$1)
I2: =COUNTIF(C2:E2,I$1)
J2: =COUNTIF(C2:E2,J$1)

then copy those formulae down to row 21.

Hope this helps.

Pete

[loginjmor]

Hi

Try the attached.

Hope this helps.

[oeldere]

I used the macro Sub CONVERTROWSTOCOL()

and after that a pivot table.

see the attached file.