There have been a few times now that I have wanted to do something in Google spreadsheets that I know exist in Excel. However, that functionality doesn't exist yet in Google. So my answer....make it yourself.
I have found that there are thousands of people worldwide who are creating cool scripts and formulas to upgrade the functionality and use-ability of Google Spreadsheets - so Google it and find their awesomeness!
Watch the following 'How To' to show you how you can create your own formula for Google Spreadsheets and how I use a particular formular that I love: 'Count Coloured Cells'.