Counting cells by font colour - Office 2011 Mac

[Really Simple]

Dear all, todays problem is;

I have a spreadsheet of people who have registered their interest in sending their children to our new school. So far 1200+ families have registered their names and their children's dates of birth;

I have used conditional formatting to define the children by year group of the children and colour coded them -
yeargroups.png

As I say there are 1200+ rows and up to 6 columns of data.

PART ONE:
I am looking for a way of counting the number of children in each year group - each defined by the colour code.

PART TWO:
The sign up form needs (to meet the government requirements) to have three further options - in essence a question "would you send your child to this school as your First Choice?" Yes, Maybe and No -

Screenshot 2014-03-27 12.44.15.png

We need to offer three totals per year group, total Yes, Total Maybe and Total No.

Any help with this challenge will be most gratefully received.

[Really Simple]

I thought the answer might have been found - in part here - http://www.get-digital-help.com/2013...nd-font-color/

Please Login or Register  to view this content.

But I am still seeing #NAME? - is this an issue with Office 2011 for mac?