[Solved] Using Data Pilot

[williaba]

Sheet 1
number-Column A contains dozens of numbers - some repeated.
text-Column B contains either yes or no against each number.
A number (say, 2345) could appear 10 times in Column A with 6 occurrences of yes and 4 occurrences of no in Column B.
This could vary weekly.

Sheet 2
number-Column A contains a distinct list of the numbers found in Sheet 1.
Column B has to indicate the number of occurrences of yes on Sheet 1 for each number on Sheet 2.
e.g.
col A col B
2345 6

Is this possible? Thanks.

[Villeroy]

This is what a data pilot is made for. Make shure, your list has a row of column headers.
Select your list (or entire columns if there is nothing else on the sheet)
Data>Pilot>Start...
[X] Create piot from current selection, [OK]
Next dialog...
Button [More Options]
Set A1 of second sheet as target for the resulting pilot
Check all other options
Drag the yes/no field (B) to "Column Fields"
Drag the categories (A) to "Row Fields"
Drag the categories (A) to "Data Fields", double-click and set function "Count"
[OK]

Please change the subject line of your initial thread to something meaningful in order to keep this forum as a searchable knowlege base. I'd suggest "Counting list items" or something.
Attached an example with pilot on the same sheet. (target: $Sheet1.$D$1)