Unable to calculate highlighted cells.

Can anyone help and excel idiot???

Please if you are able and willing to shine a light then do so in easy speak haha no technical blurb as I am not too clever with excel only know the basic when it comes to spread sheet design.
My problem is that I have recently designed a spread sheet with the full 2012 year on it. On this calendar is my shift pattern for each individual month. Every shift involves two travel days (there and back) so on the spread sheet I have highlighted my shift pattern in grey and the each time I have a travel day that cell is coloured green. Is it possible to somehow have the excel mega brain calculate only cells highlighted green and then another calc to count grey cells? Make sense????
I know how to do calculations within the cell by doing = and then the cells I want to calculate but never highlighted cells only!
Please help,
Also I'm on 2010 MS Office

Cheers

Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

the short answer is don't highlight cells then try to count them

there is no function to count highlighted cells, you could use vbacode to do it tho'

Try this UDF:

In one cell (i.e. A1) define color you want to SUM with, and then put reference in a function to that cell.

ah good old excel 4 ,forgot about the 63