How to count the occurences

[Elainefish]

Hi,

I want to count the occurences of scores in my sheet
I want to know how many times 3, 4 and 5 are being used
I want to know the count and put the results in the Summary Sheet (Sheet2)
here is the sheet sample 1QUESTION_SUMMARY FOR 3,4,.xls

[:) Sixthsense :)]

In B7 Cell of Summary Sheet

Please Login or Register  to view this content.

Copy the B7 cell and paste it to the remaining cells.

[acerrhod]

try this:
in T (3)
=SUMPRODUCT((Issue!$B:$B=$A7)*(Issue!$C:$C=B$5)) then copy down & across (4) & (5)

IN O (3)
=SUMPRODUCT((Issue!$B:$B=$A7)*(Issue!$D:$D=F$5)) then copy down & across (4) & (5)

IN E (3)
=SUMPRODUCT((Issue!$B:$B=$A7)*(Issue!$E:$E=J$5)) then copy down & across (4) & (5)

[Elainefish]

try this:
in T (3)
=SUMPRODUCT((Issue!$B:$B=$A7)*(Issue!$C:$C=B$5)) then copy down & across (4) & (5)

IN O (3)
=SUMPRODUCT((Issue!$B:$B=$A7)*(Issue!$D:$D=F$5)) then copy down & across (4) & (5)

IN E (3)
=SUMPRODUCT((Issue!$B:$B=$A7)*(Issue!$E:$E=J$5)) then copy down & across (4) & (5)

This works but I do have a follow question.
I have problems in my 10- Additional Tubine Issues (A305:314 in Summary Sheet) because in my Issue sheet, the user will have tp specify the problem
is there a way to make a wildcard to search for A - , B - , etc. 2QUESTION_SUMMARY FOR 3,4,.xls