Count words referenced to a number.

Here's a tricky one I'm really struggling to get the syntax right on.

I have a number of columns (I:O) that are either "Yes" or blank on a summary sheet.

On another sheet within the same workbook I have the raw data.

On the sheet with the raw data is a column with school numbers, each occurring multiple times.

I need to count the number of times that "Yes" occurs for each school with it being on a different sheet (Schools!) to the summary (Summary!).

There are also other columns with "Yes" and blank so it needs to reference the correct column as opposed to the entire sheet.

e.g.

Col A Col I
No. Yes/ Blank

2000 Yes
2000
2001 Yes
2003 Yes
2000
etc

Many thanks
Adam

As an addendum, the formula I have been working around is:

{=IF(VLOOKUP($A12,Schools!$A:$O,15,FALSE)="Yes",1)}

The problem with this is that I'm getting a 1 if "Yes" occurs, but not how many instances.

I'm stumped.

This is an example of the sheet. I hope this covers what you need. If not, I'll try again.

Adam

That's great. The formula there appears to work for the whole sheet correctly.

Many thanks
Adam